How do I replace/ recode string with unique number

[#1]

I have a dataset with > 1M rows and a particular 'Supplier' column with 3400 unique suppliers (data type Character, Nominal). These suppliers have a rather user-unfriendly format, e.g; '0x384D5E35468AB867642A475A2B526AE264E37B9E'. How can I replace (recode into new column?) the 3400 suppliers by a unique number from 1 -> 3400?

(In Excel I would create a Pivot table and then re-match using xlookup)

Using JMP 17.2.0

[#2 · Accepted solution]

You can do similar thing using Summary in JMP. Create new summary table with your name column as group, then add new column from right click menu (Row()) and join that back to original table

jthi_5-1695721168153.png

or maybe use value codes. From recode

jthi_0-1695721051564.png

jthi_2-1695721071876.png

go to column properties of that column and disable "Use Value Labels"

jthi_3-1695721093080.png

[#3]

Thank you Jarmo,

your first suggestion worked very well to address my issue.

Best regards,

Werner