Header changes from tFileInputExcel to tFileOutputDelimited

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

Hi Guys,

I have one query,

I have one excel file with header name, age, home. I need to convert this to .csv for that I am using tFileOutputDelimited with "|" separator. on top of it my output file should have filename , rowcount, system date.

below is my flow

tfileInputExcel will have two rows with Schema name, age, home

which will store the data's in temporary data using thashoutput

tfixedflowinput will create my filename,rowcount,systemdate. I am writing it on my out file.

where in the same file I need to write my temporary file data so I am writing through thashInput to tFileOutputDelimited.

My tFileOutDelimited is having different schema name,age,home,state

but I am unable to get this schema at my output file.

my output file should looks like below

instead I am getting output like below

overall I need to a tfileoutputfileDelimited schema as my header instead I am getting my tFileinputExcel schema as my header .

Help me to resolve this issue please

Regards,

Abisha

Re: Header changes from tFileInputExcel to tFileOutputDelimited

akumar2301 — Mon, 25 Mar 2019 20:32:23 GMT

In tfileinputexcel, put header as 1

And in tfileoutputdelimited select your include header

Re: Header changes from tFileInputExcel to tFileOutputDelimited

Anonymous — Tue, 26 Mar 2019 08:50:30 GMT

Hi Abhishek,

I tried but still it didnt work can you guide me?

Re: Header changes from tFileInputExcel to tFileOutputDelimited

manodwhb — Tue, 26 Mar 2019 10:50:39 GMT

@abishagopalan ,populate header the below way.

topic Re: Header changes from tFileInputExcel to tFileOutputDelimited in Talend Studio

Header changes from tFileInputExcel to tFileOutputDelimited

Re: Header changes from tFileInputExcel to tFileOutputDelimited

Re: Header changes from tFileInputExcel to tFileOutputDelimited

Re: Header changes from tFileInputExcel to tFileOutputDelimited