Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
It’s World Statistics Day! To honor the theme of the day, the JMP User Community is having conversations about the importance of trust in statistics and data. And we want to hear from you! Tell us the steps you take to ensure that your data is trustworthy.
Populate new column based on values of another column
Jun 15, 2012 12:34 PM(9251 views)
I'd like to do something like an Excel VLOOKUP ---- where I'd like to populate an empty new column (New_Status) with values from the original column (STATUS) --- but some of the values need to be translated.... many of the original status entries do not state explicitly that the item is 'Open' but for my purposes they are open.... so I'd like a column that consolidates all the text that means 'open' to the word 'open...