Sorting sheets on Excel Output

Hi,

I need your help, please.

I have my Alteryx workflow with several outputs that have to be placed on the excel file in the same order that is into the workflow.

I'm getting the excel file but the sheets are in different sort order.

How can I get the sheets in the same order as the workflow is the output is sorted?

Please find attached my workflow and the output that I'm getting

Regards,

Gilberto

Copy of 3WM Metrics (009).xlsx

3 Way Match Metrics - eMail.yxmd

Developer Tools

Accepted answers

jamielaird

Hi @glombard ,

I've made some changes to your workflow that should ensure it writes out the sheets in the correct order.

You had a few too many Block Until Done tools. You only need one before each output in each stream (most of your streams had two).

I've also attached a simpler workflow that demonstrates the concept on a smaller scale. In the context of your workflow, here's a screenshot showing how this translates:

Let me know how you get on with this.

Jamie

SheetOrdering.yxzp

3 Way Match Metrics-bkp_JL.yxmd

glombard

Hi @jamielaird

Thank you so much for your help.

The solution provided is working flowless.

I appreciate your help and time on this matter.

Regards,

Gilberto

All comments

jamielaird

Hi @glombard ,

You're on the right track using Block Until Done, but you need to create a link between the different streams to get the desired behaviour*.

A technique I often use is to:

1) From the 2 or 3 output of your first Block Until Done add a Summarize tool

2) In Summarize calculate the count of any field (or any other operation that will only generate ONE record)

3) Append this single record to your second stream and make sure the appended field is NOT selected (this means you are basically appending nothing)

4) Repeat as needed

You can see this in the below screenshot:

* technically a set of unlinked Block Until Done tools can be used to control the output order (they will execute in order based on the Tool ID) but I don't generally recommend this approach

glombard

Hi @jamielaird

Thank you for your help and comments.

I did what you suggested but I'm not getting the results needed on the sheets order.

Please find attached my workflow updated and let me know what I did wrong.

I appreciate your help on this matter.

Regards,

Gilberto

3 Way Match Metrics-bkp.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703