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
Solved! Go to Solution.
Perhaps you can add RecordID tool before join. Sort by record ID after join and see if that works
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 |
@Brian_Stoffel Check out the workflow
That did the trick. I appreciate it. Thanks!