Header changes from tFileInputExcel to tFileOutputDelimited

[Anonymous]

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

[akumar2301]

In tfileinputexcel, put header as 1

And in tfileoutputdelimited select your include header

[Anonymous]

Hi Abhishek,

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

[manodwhb · Accepted solution]

@abishagopalan ,populate header the below way.