TfileList Multiple Files iterate into 1 inputdelimited

One Star

TfileList Multiple Files iterate into 1 inputdelimited

Hi,
I have 6 files in a folder with similar structure. I wan to copy data from all the files into 1 single file with some computation. I have created on tfilelist which point to a folders and used filemask *emp*.txt. How do I merge all this file into 1 tfileinputldelimited and use tmap for computation and tmap is then connected to 1 tfileoutputdelimited.

tfileist-->tfileinputldelimited -->tmap-->tfileoutputdelimited.
tfilelist will have multiple files
Regards
PB
One Star

Re: TfileList Multiple Files iterate into 1 inputdelimited

Hi
Does you have same computation in all the incoming files? if yes, make a temp input delimited file using tfilelist i.e. combaning all the input files into one
tFileList--iterate--tFileInputdelimited--->tFileoutputDelimited(temp file with append option checked to add data into the temp file)
Now use the temp file and do computation and save the output
tFileInputDelimited(temp file)---> tMap--->tFileOutputDelimited (Output File)
Highlighted
One Star

Re: TfileList Multiple Files iterate into 1 inputdelimited

if you dont want to create a temp file.
you can just select the "Append" check box in u r tfileoutputdelimited. and your design should be fine.
tfileist-->tfileinputldelimited -->tmap-->tfileoutputdelimited.

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now