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

Anonymous — Sat, 16 Nov 2024 04:58:34 GMT

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.

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

Anonymous — Wed, 21 Aug 2019 08:48:53 GMT

Hello,

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

Best regards

Sabrina