Rename Column-Names using a Excel-File

[Anonymous]

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

[Anonymous]

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