Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Union issue

Wynn
8 - Asteroid

Hi! I'm having some issues with order of the dataset after the union. Could anyone please help? I'm trying to have the "subtotal" row at the bottom of the dataset instead of being at the first row. However, I don'n know how to change this settings of the union tool so that row 2-6 will be at the top and row 1 will be at the bottom after using the union. Thank you!

 

See attached workflow and input.

2 REPLIES 2
fmvizcaino
17 - Castor
17 - Castor

Hi @Wynn ,

 

The only thing you need to do is to check the option 'set a specific output order' in the union tool as image below.

fmvizcaino_0-1579895313079.png

 

Best,

Fernando Vizcaino

LukeG
Alteryx Alumni (Retired)

@Wynn 

 

In the configuration of the union tool, you have the option to Set a Specific Output Order.

 

Bottom Right has Output Order OptionBottom Right has Output Order Option

 

This allows you to move the subtotal to the bottom.

 

Let me know if this helps or if you have any questions!

 

-Luke

Labels