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.

Thanks

Sam

Developer Tools

Accepted answers

LordNeilLord

Hey @SR

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

All comments

LordNeilLord

Hey @SR

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

CharlieS

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.

LordNeilLord

Sorry @CharlieS

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

gwiz

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703