Hi

There is a [Bugtracker] feature 0000507

Best regards

         shong

Hi

For some reason Talend won't auto detect the schema from the excel file unlike a delimited file. Is that normal ?

Which version of TOS did you use?

Best regards

         shong

That would be good if I wanted to merge two schema's of two excel files. But actually I asked you the wrong question.
For some reason Talend won't auto detect the schema from the excel file unlike a delimited file. Is that normal ?

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 !