topic Re: merging excel file with multiple sheets in Talend Studio

merging excel file with multiple sheets

Deley18_ — Sat, 16 Nov 2024 00:27:01 GMT

Hi, please I have two identical excel files that has two sheets each .

excel file 1 (sheet1 and sheet2)

excel file 2 (sheet1 and sheet2)

I am trying to merge the two files into one file like below

excel file 3 (sheet1 and sheet2)

I am able to merge the excel file 1 and excel file 2 using tunite for only sheet1, how do I go about the sheet2

Thank you

Anonymous — Fri, 12 Mar 2021 06:41:15 GMT

Hello,

Please try to use this work flow;

tFilelist --------iterate------ tFileinputExcel ---------tMap------tFileOutputExcel

and make "add to existing file" option checked.

Using thashoutput and then using thashinput will meet your needs as well.

Best regards

Sabrina

Deley18_ — Fri, 12 Mar 2021 09:58:26 GMT

Thanks for the heads up, I used the flow below

Deley18_ — Fri, 12 Mar 2021 09:59:25 GMT

Anonymous — Mon, 15 Mar 2021 08:53:48 GMT

Hello,

Great it helps. Feel free to let us know if there is any further help we can give.

Best regards

Sabrina