topic 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? in Discussions

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

VariancePanther — Fri, 27 Oct 2023 09:00:06 GMT

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

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?

Ressel — Fri, 27 Oct 2023 09:08:53 GMT

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.

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?

jthi — Fri, 27 Oct 2023 09:08:48 GMT

Contains(:Description, "WORD") > 0

Formula column with above formula using Contains()