I am trying to solve a tricky problem
I have a survey with answers like "happy", "unhappy", etc. I need to assign a numeric value for rating - "happy = 1"
I know a can do conditional column. But there is a lot of words, and the numeric values might change.
What I want to do is create a separate table with words in one column, assigned value in another, and then in the main table create a new column based on the rule set in this small separate table...