How to load TFilelist files data to multiple MySQL output tables

[Anonymous]

Hi,

I used tFilelist to load files from a Directory to Talend. I need the data to load from these files from tFilelist to different MySQL output tables. I am using Talend Open Studio. 

Please help me to design a job for this requirement

File1----->table1

File2----->table2

Thanks & Regards

SJ

[akumar2301]

How do you know that mapping between file and table ?

e.g. File1 should go to Table1 and not to Table2

[Anonymous]

Hello @SP_BI

Can you follow this url below

https://community.talend.com/t5/Design-and-Development/how-to-load-multiplefiles-into-multiple-table...

[Anonymous · Accepted solution]

Hi,

    I am assuming both files are having different schema which means target tables are also having different schema.

    The simple way is as shown below.

You have to map the file name from tFileList (you can get the value by giving Control+Space) and matching it with the value you are planning. The tJava is not having any data in it and it is used for just controlling the flow.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hi, thanks for the quick response.

The first file and the first table will have the same schema. similarly for the second file and second table. so we could do the mapping using a condition right?

[Anonymous]

@nthampi   This solution worked for me. Thanks a lot.

[Anonymous]

@ksingh  Thanks for the quick response. I will try with the steps provided in the link.

[Anonymous]

@SP_BI  yes you can but @nthampi  gave a good solution which is lot simpler, then the link i sent you