I have a csv file (attached) to load in my db table and I have this requirement based on a specific field:
In my CSV:
if field code_operator1=BETWEEN_START must exist code_operator2=BETWEEN_END
The problem is that in my Table I have only one field code_operator, instead in cvs I have code_operator1 and code_operator2. How can I insert code_operator2 after code_operator1 in the database column (code_operator)?
I have the same issue for code_entity and attr_value fields.
In need to find a way to insert data in my Table as follow:
as variant - read file twice ind insert into database
uid - Numeric.sequence("s1",1,2) code_operator - code_operator1 code_entity - code_entity1 attr_value - attr_value1
and second time:
uid - Numeric.sequence("s1",2,2) code_operator - code_operator2 code_entity - code_entity2 attr_value - attr_value2
in this case, you will keep sequence for rows, BETWEEN_END will follow after BETWEEN_START
possible there are other solutions could be there
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Learn how and why companies are moving to the Cloud
Accelerate your data lake projects with an agile approach