Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

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
Labels (2)
2 Replies
Anonymous
Not applicable

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)
Anonymous
Not applicable

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.