Mapping Columns using another csv file and transfering data from a csv file to a mysql database

Highlighted
Four Stars

Mapping Columns using another csv file and transfering data from a csv file to a mysql database

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.

Highlighted
Moderator

Re: Mapping Columns using another csv file and transfering data from a csv file to a mysql database

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Self-service Talend Migration: Moving from On-Premises to the Cloud

Move from On-Premises to the Cloud by following the advice of experts

Read Now