681212_en-US

liliconcom

How do I replace/ recode string with unique number

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

Basic Data Analysis and ModelingData Exploration and VisualizationRe: How do I replace/ recode string with unique number

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

 

or maybe use value codes. From recode

 

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

 

Re: How do I replace/ recode string with unique number

Thank you Jarmo,

your first suggestion worked very well to address my issue.

Best regards,

Werner