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

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