merging excel file with multiple sheets

[Deley18_]

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 · Accepted solution]

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_]

Thanks for the heads up, I used the flow below

[Deley18_]

[Anonymous]

Hello,

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

Best regards

Sabrina