Merging an excel output divided by sheets

Question

Hello everyone, so I'm kinda new with using this super awesome tool. I have added 4 containers that outputs different Excel data. Is there a way that when I run all containers at once, I get a merged excel file with 4 tabs, 1 for each container respectively?

outputs1 to 4.PNG

finaloutput per sheet.PNG

binu_acs · Answer

@wila666 One option is to add a formula tool in each container and crate a field name called 'Sheet Name' then assign the value Sheet1 to the first container , Sheet2 to the second container etc. Then connect to the output tool and change the settings like below. Attaching a sample workflow for your reference.

Multi_Tab_0829.yxmd