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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Appending data to a list of files.

Hi group, I am a newbie to Talend and am stuck with this task. I've a raw file with 5 lines and 10 files in a directory. My requirement is to append these 5 lines as first 5 lines in each of the 10 files. Please comment any ideas!

Labels (2)
5 Replies
manodwhb
Champion II
Champion II

use tfilelist to list all the files and iterate flow to tfileinputdelimited and the on target, tfileoutputdelimited enable Append.

Anonymous
Not applicable
Author

Unfortunately append will only append to the end of the file....not the beginning. This needs to be thought about in a different way. Use the tFileList and iterate over the files as @manodwhb suggested. But in each iteration use a tFileCopy to copy your file with 5 rows to a new name. Then read from your files that are being iterated over and append that data to the end of the new file you've copied.

 

Anonymous
Not applicable
Author

can you please elaborate your answer. Are you suggesting to connect tFileList to tFlowToIterate (which isn't possible)? or are you suggesting in another way.

manodwhb
Champion II
Champion II

@Pruthvi,you should desing as shown in screenshot.0683p000009LsS2.png

manodwhb
Champion II
Champion II

@Pruthvi,still do you an issue?