How do I assign a new column with categorical data which is defined by specific tag words contained in another column of my data?

[#1]

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. 

VariancePanther_0-1698396833553.png

What is the best way to do this?

Thx in advance

[#2 · Accepted solution]

See if the attached example is what you want. It contains a formula column in column "WORD?" that looks like this:

Ressel_0-1698397601504.png

You should be able to change the string ("WORD") to any other string to match your search criteria. Respond, if you need more help.

[#3 · Accepted solution]

Contains(:Description, "WORD") > 0

Formula column with above formula using Contains()