How to combine multiple excel sheets to one excel sheet

[kuwaryogi27]

Hello All,

I have a use case where reading excel sheets and combining them to one sheet, I am able to do this but the issue I am facing is the headers from all the sheets are also getting appended in the file.

Sharing the excel below in the attachment, kindly have a look.
Please guide me for the same.

Kind Regards,
Yogesh.

[manodwhb]

@ykasture , you need to us tUnite component before the tExcelFileOutput component in your job.

[kuwaryogi27]

Hello @manodwhb ,

But to use tUnite we need to have fixed excel input or fixed sheet names then only we can use tUnite.
In my case the sheet names starts with PC_ and there are 'n' number of sheets and when I am combining them the headers of all sheets are getting appended to the excel file.

I have solved this issue using tMap where we can say !row_name.column_name.equals("headerName") [any one header name] this solves the problem.

Sharing the screenshot configuration of tMap below.

tMap_Consolidate.PNG

[manodwhb]

@ykasture , yes with that approach you need to have fixed structure. you can try with dynamic option try that let me know is that working?

[kuwaryogi27]

Hello @manodwhb ,

Didn't get your point as mentioned in my above comment I solved this in tmap you can see the screenshot in the same comment.

Are you suggesting any other dynamic option?

Kind Regards,
Yogesh.