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; } } }

Converting a number in one column to a word in another column

kevin_herlihy_l

Hi all,

This is probably covered elsewhere but I couldn't find it. I'd like to make a formula that will give a specific word for a given value in a separate column. See below:

Column	Value	Word
1	3	Orange
2	3	Orange
3	4	Red
4	5	Green

Any tips on how I can accomplish this?

Thanks!

Accepted answers

KarenC

Another option is to use recode with the formula column option (drop down in upper left of dialog), click ok when asked if you want to convert to character (JMP converts the new column to character). The result is as provided by Jim but with JMP doing the formula writing.

All comments

txnelson

This can be done with an IF() statement structure or with a Match() function or other. I prefer

Match(:Value, 1,"Red", 2,"Orange",2,"Green"...........)

KarenC

kevin_herlihy_l

@KarenC wrote:
Another option is to use recode with the formula column option (drop down in upper left of dialog), click ok when asked if you want to convert to character (JMP converts the new column to character). The result is as provided by Jim but with JMP doing the formula writing.

Thanks Karen!

I thought there was a way to do it like this. I was struggling with the match formula.