using text input to reorder record IDs

[Ksisterhen]

Hi -

needing help on how to use the text input tool so that I can reorder my records based on a unique recordID line up.

i.e recordIDs currently show in numerical order and I would like to change it to 1, 2, 4,6, 3,5

[alexnajm]

You could use a Multi-Row Formula tool to assign a RecordID based on the logic of your choice - unsure what the logic is beyond the first six rows but this tool should help!

[BS_THE_ANALYST · Accepted solution]

@Ksisterhen 
I'd do it like this:
Original data on the top stream

New ids on the bottom stream:

Use the Join tool with Record Position:

It will create that manual matchup, then you can sort on the id column after.

All the best,
BS

[Ksisterhen]

Still having issues, it is sorting in the wrong order see screenshots

[alexnajm]

@Ksisterhen follow the configuration of @BS_THE_ANALYST above - for example you are still using a RecordID tool and joining on key fields which would not work for this solution!