nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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 Modeling

Data Exploration and Visualization

Comments

There are no comments yet

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of