Output Data Order From a Join Tool

[Brian_Stoffel]

Output Data Order From a Join Tool

How do you set the data order in the output of a Join tool?

Example:

DataFile A

Column A
222222
1111111
444444
333333

DataFile B

Column A Column B
444444 Cat
1111111 Dog
222222 Tree
333333 Apple

Join Output

Column A Column B
1111111 Dog
222222 Tree
333333 Apple
444444 Cat

How do I keep the data order from DataFile A after the Join in the output? Should I be using another tool? I am looking for the below output data order after the join.

Column A Column B
222222 Tree
1111111 Dog
444444 Cat
333333 Apple

[MilindG · Accepted solution]

Perhaps you can add RecordID tool before join. Sort by record ID after join and see if that works

[Brian_Stoffel]

This is what I am receiving after the Join.

Column A	Column B
1111111	Dog
222222	Tree
333333	Apple
444444	Cat

This is what I'm looking for after the join.

Column A	Column B
222222	Tree
1111111	Dog
444444	Cat
333333	Apple

[MilindG]

@Brian_Stoffel  Check out the workflow

[Brian_Stoffel]

That did the trick. I appreciate it. Thanks!