I found a way to do this, but it's kind of ugly and I'm hoping there is a better way.
I'm comparing the data on 2 reports. I need 1 tab with all the records that match, another tab with the results from the left join, and a third tab with the results from the right join.
I want to save them all into 1 workbook - but as you probably guessed, I got errors when saving since the 3 outputs tried to write to the same file simultaneously.
Anyway, my solution was to:
1 - do the join,
2 - Add a Block Until Done
3 - Add a filter to each of the 3 Block until Done filters, one for each of the 3 outputs I need. (matches, left join, right join)
4- Add an output to each filter that writes to a different tab in a single workbook.
It works but I don't like it. I'm wondering if there's a better way.
I've looked into Parallel Block Until Done, but network security won't let me download that macro, and I'm not even sure if they'll let me upload it to our Alteryx server, which will also be required. So - I'm wondering what other options there might be.
Package is attached as well as a screenprint of the pieces described above.
Any help is appreciated, even if the response is 'yeah, that's all you can do'. :)
