Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filter out certain data cells if they have certain letters

Dittau
8 - Asteroid

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

 

1 REPLY 1
martinding
13 - Pulsar

Hi @Dittau,

 

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

 

The ! means not.

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels