I have a very large dataset I'm working with (too big to manipulate in Excel). One character string variable has about 30 unique values. I want to create a new variable where the 30 values are grouped into only 5 values. (ex. "Hair_Brush" and "Toothbrush" would both map to "Brushes" in the new variable). This would allow me to look at my data on a higher level, should I choose to do so.
In Excel I would just add a new column, create a mapping file, then use VLOOKUP to map the 30 unique values to the 5 parent values.
So I'm looking for a node where I can set up mapping rules to create this new variable.
You should have a look at the Cell Replacer:
Create a table with your groupings (which is what you did in your first post) and then apply the cell replacer to your real data with the "Append new column"-option checked.