Import the data with different schema from ExcelFile to mysql table

[hami1]

Hi Guys,
I came across the same kind of requirement where we need to import the data from ExcelFile to mysql table. But here the Schema is different in both the sheet's. How can I capture these Dynamically changed schema's in the Talend and load the right amount of data in the table.

Thanks,
Hameed S.

[Anonymous]

Hello Hameed
The dynamic schema feature is only available in Talend Enterprise Subscription product, for more information, please read  How to process changing data structure?
Assuming you have multiple excel files and each file has different schema, a simple job looks like:
tFileList--iterate--tFileInputExcel--main--tMysqlOutput
on tFileInputExcel, just need to define one column with dynamic data type.
on tMysqlOutput, set the table name as current file name, each file will be loaded to corresponding table in database.

Regards
Shong

[hami1]

Thanks Shong for your quick reply,
Here am using Talend Open Studio 5.5.0 Version, Is there any way that I can handle this scenario in Talend Open Studio.

[Anonymous]

Hello
Unable to achieve it in a single subjob with community edition, you have to create several subjobs to map each schema.
Regards
Shong