topic Re: How to load TFilelist files data to multiple MySQL output tables in Talend Studio

How to load TFilelist files data to multiple MySQL output tables

Anonymous — Thu, 07 Mar 2019 14:30:52 GMT

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

Re: How to load TFilelist files data to multiple MySQL output tables

akumar2301 — Thu, 07 Mar 2019 14:48:42 GMT

How do you know that mapping between file and table ?

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

Re: How to load TFilelist files data to multiple MySQL output tables

Anonymous — Thu, 07 Mar 2019 14:59:19 GMT

Hello @SP_BI

Can you follow this url below

https://community.talend.com/t5/Design-and-Development/how-to-load-multiplefiles-into-multiple-tables-and-the-have-to/m-p/25421#M4360

Re: How to load TFilelist files data to multiple MySQL output tables

Anonymous — Thu, 07 Mar 2019 15:41:45 GMT

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 🙂

Re: How to load TFilelist files data to multiple MySQL output tables

Anonymous — Thu, 07 Mar 2019 18:09:53 GMT

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?

Re: How to load TFilelist files data to multiple MySQL output tables

Anonymous — Thu, 07 Mar 2019 18:10:48 GMT

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

Re: How to load TFilelist files data to multiple MySQL output tables

Anonymous — Thu, 07 Mar 2019 18:16:49 GMT

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

Re: How to load TFilelist files data to multiple MySQL output tables

Anonymous — Thu, 07 Mar 2019 18:19:06 GMT

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