Append row to the existing CSV file

[Anonymous]

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

[manodwhb]

@abishagopalan, check the below job.

[Anonymous]

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.

[manodwhb]

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

[Anonymous]

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

[manodwhb · Accepted solution]

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

[Anonymous]

Thanks Mano.