Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Outputting all 3 results of a join to separate tabs in the same workbook

Phermes1
7 - Meteor

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'. :)

 

2 REPLIES 2
binuacs
17 - Castor

@Phermes1 One way of doing this is by assigning a Sheets name in each output and then writing it into a different tab in the same output. 

 

Note: I also removed some of the tools 

binuacs_1-1674669697754.png

 

 

 

Phermes1
7 - Meteor

I like that much better! Thank you!

Labels