Output as excel

[samxhander09]

Hi community, Im trying to output to excel but i keep getting different error messages. Basically i have 4 data streams that I want to output in one excel but different tabs/sheets, i can't figure out how to make it work and hoping to get help here. Im attaching a sample workflow and an excel file of what im trying to achieve.

PS i added interface tools so users can update the output file path more dynamically.

[binuacs · Accepted solution]

@samxhander09 try the attached workflow

[cjaneczko · Accepted solution]

What is the error message you are getting. Is it that the file is already open? If thats the case you'll want to use the new Control Containers if you have the most recent version of Alteryx. If you are using an older version you'll need to use Block Until Done on each path. If you said you had 4 paths, you'll need 2 BUD's. 

[samxhander09]

@binuacs I made some tweaks and finally got what I wanted. Thanks for sharing your approach! Appreciate it so much. 

[Hadiram]

Something like this would work