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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
TugaMade
Contributor
Contributor

CSV Files updating

I need to insert an equal header line with the data fields names on top of various CSV files that only have data records and are inside a windows directory.

I think I may have the solution of the job design for the insertion of the header in a single CSV file, but I am very confused with which Talend components I need to pick and how to aply them to update all of the CSV files inside the directory.

Can someone help me please?

Labels (2)
2 Replies
TRF
Champion II
Champion II

tFileList-->tFileInputFileDelimited-->tFileOutputFileDelimited

That's for the flow design. As soon as the header field names are compatibles with Java naming rules you just have to define the shema with the names you want and tick the option "header line" for the output. If names are not compatible you need to merge a template file with each input files or to force a specific line un the output before starting to push records from the input file. This may be done with tFixedFlowInput.
TugaMade
Contributor
Contributor
Author

I tried your solution with the data file as the input file and the output file with the header already filled but it not works, also named the files as "a", "b" and "c", the iteration run 3 times but afterwards does not happen anything. 

 

0683p000009M5ox.png


Job.zip