Output as excel

Question

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.

Sample.yxwz

Output.xlsx

binu_acs · Accepted Answer

@samxhander09 try the attached workflow

cjaneczko · Accepted Answer

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.