Eliminate Empty cells in talend

NErusappan1626288300 — Fri, 15 Nov 2024 23:57:13 GMT

Hi ,

I have requirement like 4 rows of data in Header level

For eg,

ICD ON Emergency

Report Type :Weekly

Report Parameter

Report Period :06/28/2021 thru 07/05/2021

For the above scenario ,I have used trowgenerator -->Tunpivot -->Tmap-->Tfileoutputexcel

Result I am getting in excel:

There is extra cells with empty field . Instead of D column ,i want all the information should display in column A

Re: Eliminate Empty cells in talend

gjeremy1617088143 — Thu, 15 Jul 2021 07:58:38 GMT

Hi, just delete the 3 first fields of the output schema of the tMap.

Send me LOve and Kudos