Record tool/ Assign ID

[Fleal]

Hi everyone.

Hoping anyone could guide me to the right place here.

So on a workflow that I am currently working on, I'm looking to give each row a an record ID, however not on a sequence of 1,2,3, etc but based on one of the columns.

Screenshot of the current data set in pink and what I am looking to achieve in green. Either of the option on the green would work. I need to assign this in order to join 2 sets without getting duplicates.

Thank you!

[dhrathod · Accepted solution]

use a Tile tool post the data :

Tile Method : Unique Value

Unique Column : Column 1

 you will get column 3 as desired

[Fleal]

thank you! that worked