community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Maintaing sort order after join tool

Asteroid

HI All,

 

I want to maintain my original sort order one the column i am using to join with another input. the 2nd input column is not order the way i need and its causing the original column to lose its sorting after the join. Any way i can avoid this.

 

Thanks

Sam

Alteryx Certified Partner

Hey @sr49ers

 

You could add a recordID before the join and the re-sort based on that recordID after the join.

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

Alteryx Certified Partner

Hi Sam.

 

Any fields that are involved in the Join process will be sorted by the joining tool. What I recommend is to use a Record ID tool before the join tool, and then sort by the assigned Record ID field after the join is complete. 

 

Let me know if you have any questions.

 

 

Edit: @LordNeilLord beat me to the answer again. I need to stop leaving these windows open so long.

Alteryx Certified Partner

Sorry @CharlieS

 

I'm leaving work now, so the questions are all yours :)

Alteryx Certified Partner

The important thing is that users get the solutions they need. I'll be around for the American workday. Have a good evening, @LordNeilLord.

Asteroid

Thank you both! the record ID worked. such a simple solution!! appreciate your help.

Labels