How to create a new column with numerical number based on the unique grouping of column A

Question

I have a table with Column A (char). I want to add a new column in number value which represents the grouping of column A. How to do this automatically? Column A has too many characters for me to manually group them.

column Anew columnkkk1dd2kkk1cc3

WebDesignesCrow · Accepted Answer

May be can use Cols --> Utilities --> Labels to Code (it automatically assign a code based alphabetical order)? Then you create new column using below formula; :new column << Set Formula( Col Stored Value( :Column A ) );

JMP2021 · Accepted Answer

thank you. It worked.

JMP2021 · Accepted Answer

one more question is that the code is sequential given. I wonder if there is a way to assign the number based on the highest occurrence in column A.