how to process multiple csv files using single tfilelist component in talend?

Five Stars

how to process multiple csv files using single tfilelist component in talend?

Hi Team,

I have a scenario where I have two different set of continous csv files with different metadata for emp and dept files. The file names will be (emp_1.csvemp_2.csv..... emp_10.csv) and  (dept_1.csv,dept_2.csv, dept_3.csv).Both the set of files are in same folder

Is it possible to process both the set of files using single tfilelist component or i should use two different flows with two tfilelist components each for emp and dept.

 

tfilelist -> tfileinputdelimited -> tmap -> tDBOutput ( is this correct to process both set of files)

Or is there any other way to achieve this.??

 

Could anyone reply asap?

 

Thanks,

Kiran Kumar

Nine Stars

Re: how to process multiple csv files using single tfilelist component in talend?

1)

after iterator link use dummy tJava and then two run if based on file name

 

 

2) use dynamic schema if there is no transformation before load.tDboutout change table name based on file name

Regards
Abhishek KUMAR

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads