How do I assign a new column with categorical data which is defined by specific tag words contained in another column of my data?Hi Community,
I have a set of data, containing a column with part nr and a column with varying descriptions of the corresponding numbers.
Based on that data, I want to add another column, that automatically labels all rows which contain "WORD" in the description column as 1, the others as 0.
What is the best way to do this?
Thx in advance
Data Blending and CleanupData Exploration and VisualizationRe: How do I assign a new column with categorical data which is defined by specific tag words contained in another column of my data?Contains(:Description, "WORD") > 0
Formula column with above formula using Contains()
Re: How do I assign a new column with categorical data which is defined by specific tag words contained in another column of my data?See if the attached example is what you want. It contains a formula column in column "WORD?" that looks like this:
You should be able to change the string ("WORD") to any other string to match your search criteria. Respond, if you need more help.
