I had to import several data type columns into jmp as numeric (coded 1-4, for example). I'd like to convert the numbers to more meaningful characters. For example in a column labeled "SITE", I'd like to make the following change:
1==DL 2==SL 3==KA 4==MP
Should this be done in the formula editor with a series of IF statements, or is there a cleaner way. If I use IF statements, then how can I delete the original numerically coded columns. Thanks in advance.
style="font-size: 10pt; font-family: "Courier New"; color: black;"> style="font-family: Arial;">I think the "match" function would work best. Just create a new column called SITE, and use the following formula (replacing :Column 1 with your reference column).