Eliminate Empty cells in talend

[NErusappan1626288300]

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

[gjeremy1617088143]

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

Send me LOve and Kudos