Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Maintaing sort order after join tool


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.




Alteryx Certified Partner

Hey @sr49ers


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



Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

Alteryx Certified Partner
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
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.


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


Hi @CharlieS,

What's the order the join tool sorts records in? For example, I notice that the join sorts records but not sure what the rule is/why. Could you comment to that?

Thank you!

Alteryx Certified Partner
Alteryx Certified Partner

The Join tool will sort by any field that it has been configured to join on. Feel free to PM me if you have further questions.


Is there a reference list of tools that will change the order of the incoming data inside the tool such as the Join does .  Also is there a list of tools that may require data to be in a specific sort order prior to processing such as Multi-Row?