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

How do I replace/ recode string with unique number

WernerL — Tue, 26 Sep 2023 09:26:27 GMT

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

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

jthi — Tue, 26 Sep 2023 09:39:39 GMT

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

WernerL — Tue, 26 Sep 2023 13:16:58 GMT

Thank you Jarmo,

your first suggestion worked very well to address my issue.

Best regards,

Werner