Creating a new Column based on value of another

I have what is probably a simple question. I want to create a new column based on the value in Column “Q14”. I have been using a Table Creator node as a look up using the String Replacer node to update Q14 to Desired Main, but now I also want to add a new Column for Desired NPC. Is there a way to do this using the table as a look up?

Hi @kmarrs901 , I’m a little confused about what you are asking, and what your sample table is showing, although I’m sure you are right that it is probably a relatively simple problem.

Can you show both your input and desired output datasets, and upload some sample input data (in a form that can be processed) rather than just a screenshot, as then people can more easily assist. :wink: