Filter out certain data cells if they have certain letters

Question

If a column lets say Column A has an words with tev then it gets filtered out of the filter column.  In sql its (    [column a] like ‘%tev%   ).   but that doesn’t work in alteryx so whats the code in alteryx to do that?

column a

steve

martinding · Accepted Answer

Hi @Dittau,

One way is to use !Contains([Column A], 'tev') in the filter tool.

The ! means not.