We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Merging an excel output divided by sheets

wila666
5 - Atom

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? 

1 REPLY 1
binuacs
21 - Polaris

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

 

binuacs_0-1661811449479.png

 

binuacs_1-1661811482532.png

 

 

 

Labels
Top Solution Authors