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