topic Re: CSV Files updating in Talend Studio

CSV Files updating

TugaMade — Sun, 30 Jun 2019 22:30:48 GMT

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?

Re: CSV Files updating

TRF — Mon, 01 Jul 2019 06:41:49 GMT

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.

Re: CSV Files updating

TugaMade — Mon, 01 Jul 2019 16:30:33 GMT

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.

Job.zip