topic Append row to the existing CSV file in Talend Studio

Append row to the existing CSV file

Anonymous — Sat, 16 Nov 2024 06:15:16 GMT

Hi Guys,

i have a out.csv file with 1 row. Now i need to read the input excel file input.xls and write the values in the same output.csv file with header.

How to do it? please help me

Re: Append row to the existing CSV file

manodwhb — Tue, 26 Mar 2019 07:34:35 GMT

@abishagopalan, check the below job.

Re: Append row to the existing CSV file

Anonymous — Tue, 26 Mar 2019 07:50:34 GMT

Hi Mano,

Thanks for the quick response.
In my case my input excel file has different schema and output csv file will have different schema when i map my input.xls to output file i need to get my output file headers.but i am always getting my input file header while appending.

Re: Append row to the existing CSV file

manodwhb — Tue, 26 Mar 2019 07:52:47 GMT

@abishagopalan ,can you try by selecting append and Input Header there in basic settings of tFileOutputDelimiter?

Re: Append row to the existing CSV file

Anonymous — Tue, 26 Mar 2019 09:30:01 GMT

Yes i have done

below is my output file

in this file i need to append my excel file data,

i have attached my tFileInputExcel and tFileOutputDelimited configurations with schema

tFileOutputDelimited

my expected output should like below

but what i am getting currently is like below

i am not getting the headers though i have selected tFileOutputDelimited addheaders

Kindly validate me

Regards,

Abisha

Re: Append row to the existing CSV file

manodwhb — Tue, 26 Mar 2019 10:12:08 GMT

@abishagopalan ,yes..the header is not appending,since you need to manage manually to populate header first using below way and then populate original data.

Re: Append row to the existing CSV file

Anonymous — Tue, 26 Mar 2019 10:40:55 GMT

Thanks Mano.