topic Re: How to combine multiple excel sheets to one excel sheet in Talend Studio

How to combine multiple excel sheets to one excel sheet

kuwaryogi27 — Tue, 18 Feb 2020 12:09:44 GMT

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.

Re: How to combine multiple excel sheets to one excel sheet

manodwhb — Tue, 18 Feb 2020 14:10:44 GMT

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

Re: How to combine multiple excel sheets to one excel sheet

kuwaryogi27 — Thu, 20 Feb 2020 08:13:30 GMT

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

Re: How to combine multiple excel sheets to one excel sheet

manodwhb — Thu, 20 Feb 2020 09:29:28 GMT

@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?

Re: How to combine multiple excel sheets to one excel sheet

kuwaryogi27 — Wed, 26 Feb 2020 06:01:05 GMT

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.