Union issue

Question

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.

Summary tab.xlsx

New Workflow2.yxmd

fmvizcaino · Accepted Answer

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.

Best,

Fernando Vizcaino

LukeG · Accepted Answer

@Wynn

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

Bottom 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