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
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Create systems and workflow to manage clean data ingestion and data transformation.