Joining multiple workflows into one output

[vvissamsetty]

I have two workflows which I wish to combine into one excel file but as different sheets. Can anyone guide me?

[AlteryxUserFL]

Hello, 

I would look at these two links:

Link 1: https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Output-to-multiple-sheets-within-an-Excel-fi... 

Link 2: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Re-Output-to-multiple-sheets-within-an...

If you need additional help, would you mind posting your workflow.   

[rafalolbert · Accepted solution]

Hi vissamsettyvivek,

Please look at my proposed solution in the attached files.

The trick is to batch writing into every tab and parametrise the output with tab name each time.

This is assuming every input tab may feature different schema and record-set, so these are compressed into 2 sells: headers and records and passed as values into the macro.

I'm sure there are other ways to achieve the same - please let me know what you thing of my solution?

Have fun and all the best!

Thanks,

Rafal

#Excuse me, do you speak Alteryx?

[jnans · Accepted solution]

Alternatively if there are only two workflows you can use the parallel block until, done crew macro.

Your can connect each workflow (in one file) to an input of the block until done and then designate where the output from each workflow will go. This macro is designed to do everything from input 1 to output 1 and then input 2 to output 2. This will not start workflow 2 until output 1 has completed.

[vvissamsetty]

Thanks everyone, that was helpful.