I have 2 csv files which have various columns and i have a target csv file with 2 columns and another mapping file. For Example:
Table 1: Columns : Account No., CustomerId, Customer Name.
Table 2: Columns :Customer Code, Address, Customer Name.
I have a target CSV file with Columns: CustomerId, Customer Name.
And i pass a mapping file which says:
CustomerId for table1 -> customerId of target file
CustomerName for table1 -> customerName for target file
Customer code for table2->customerId for target File
CustomerName for table2-> customerName for targetFile
Now i want the table1 and table 2 data to be populated to the target csv file based on the mapping given. How do i have achieve this.
Could you please elaborate your case with an example with input and expected output values?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Move from On-Premises to the Cloud by following the advice of experts