Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

How to load TFilelist files data to multiple MySQL output tables

Highlighted
Four Stars

How to load TFilelist files data to multiple MySQL output tables

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


Accepted Solutions
Highlighted
Employee

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

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.

image.png

 

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 :-)

View solution in original post


All Replies
Highlighted
Eleven Stars

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

How do you know that mapping between file and table ?

 

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

Regards
Abhishek KUMAR
Highlighted
Nine Stars

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

Highlighted
Employee

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

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.

image.png

 

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 :-)

View solution in original post

Highlighted
Four Stars

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

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?

 

Highlighted
Four Stars

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

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

Highlighted
Four Stars

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

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

Highlighted
Nine Stars

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

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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog