Hi,

I have alot of Excel files which I need to import into a database. Every excel file has records for a Table in the DB.
The schemas of the files look alike, except for a few columns. (i.e.: all files contain Id, CreationUser, Date)

So what I would like to do is create 1 overall schema which will be used with all xls files, and a unique one. I would then like to merge those two schemes in a tMap component and store it in the database ;-) This way, if a column changes in the excel files I don't have to manually edit all schemes.

Is this possible ? If not, how can I solve this problem ?

I'm new to Talend, so don't shoot me if I said something stupid ;-)


Thanks in advance !