maintaining order of records

[gshortr]

Hi there, I am attempting to join two excel docs one of which has a column list of chapters in the correct order - this order is neither alpha or numeric. But I need the joined output to maintain the same order as these chapters from the original source to make sure the sequence has not changed. How can I do this? Thank you!

[Luke_C · Accepted solution]

Hi @gshortr 

Add a record ID tool before the join, then after the join sort on the record ID.