Rename Column-Names using a Excel-File

Anonymous — Wed, 21 Sep 2016 14:28:17 GMT

Hi there,
im quite new to Talend Open Stuido for Data Integration, so please be gentle if my question is too simple. I did some searching, but didnt find an answer... but maybe I just didnt use the right terms for that.
I have a csv-file with some cryptic column names (at least the cryptic names stay the same all the time and dont chance position) and want to import the file into a mysql database. Renaming the column names with a tMap does work, the import into mySQL works too.

Now I want to enter the cryptic names into a excel-file and write some more readable names behind them. Is it possible for Talend to read the excel-file and rename the columns based on the values in the file?

For example:

CSV-Column-Names:
"FN00X", "LN20X", "foobarname"

Excel-file:
"FN00X", "Firstname";
"LN20X", "Lastname";
"foobarname", "Randomtext";

Mysql-Table-ColumnNames:
"Firstname", "Lastname", "Randomtext"

Thanks for any hints in advance.
Johmi

Re: Rename Column-Names using a Excel-File

Anonymous — Fri, 23 Sep 2016 06:45:23 GMT

Hello
The schema must be defined before the job execution, so it impossible to change it at run time.
Regards
Shong

topic Re: Rename Column-Names using a Excel-File in Talend Studio

Rename Column-Names using a Excel-File

Re: Rename Column-Names using a Excel-File