Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
@emilypassingham whenever you need to use the Block Until Done tool, but data is in different streams, you can use two approaches:
1) If all of your outputs are different schemas but you want them in the same Excel file, use a string of Parallel Block Until Done tools, which is a 3rd party macro created by @MarqueeCrew - http://www.chaosreignswithin.com/p/macros.html
2) If your 9 different streams are of the same format, you can just add an ID to each, union them all together and then split them out into separate sheets within the Output Data tool, you'd just need to use the bottom part of the configuration like so:
No problem @emilypassingham! The macro itself is incredibly easy to use as there's no configuration. You just need to string them together like so (I've just chained 2 together to demonstrate with 3 outputs of varying schema):
As you can see, my 3 inputs were totally different:
But I end up with a successful output:
As a final note, obviously just make sure that you give each of your 9 outputs a different sheet name to prevent further erroring/overwriting:
