Free Trial

Alteryx Designer Desktop Discussions

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

Table Render Order

jenner85
8 - Asteroid

Hi - 

I am joining several tables, and when I render them, I would like them to show up in the order that I pulled them into the join. How to I re-order them, they're showing up in my excel file reversed.

Thanks!

6 REPLIES 6
Emil_Kos
17 - Castor
17 - Castor

Hi @jenner85,

 

By any chance can you share the workflow?

 

If not can you at least make a screen so I could visualise the problem? 

Emil_Kos
17 - Castor
17 - Castor

Hi @jenner85,


I think you need to use union instead of joining. Afterwards, add record ID and sort the data afterwards.


I have prepared a workflow for you. 

jenner85
8 - Asteroid

@Emil_Kos What I've done is created two different tables, and then used the Union tool to put them together before rendering. I am going to have several tables I will be adding to the union, and then rendering by employee name to several different outputs. Is there an option to reorder the tables to come out of the union in the order they were put into it?

 

 

jenner85_2-1624623864357.png

 

jenner85_1-1624623764910.png

 

jenner85
8 - Asteroid

This fixed my issue: 

jenner85_0-1624626664908.png

 

Emil_Kos
17 - Castor
17 - Castor

Hi @jenner85,

 

I am happy that you made it work! Sorry that I wasn't able to give you a working solution but I think I wasn't able to fully understand how to help you. 

apathetichell
19 - Altair

That box and the "manually configure fields" option are the secrets of getting the Union tool to work for you...

Labels
Top Solution Authors