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.

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 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

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

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog

Talend Studio Improvements for API Services

Taken a look at the Talend Studio improvements for API Services

Watch Now