Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Filtering out rows containing specific text

Sammy22
8 - Asteroid

hello,

 

i have data like below and want to filter out anything that has 'abc' but without removing 'no abc'. example of the data below. Only the ones in red would be removed. any help?

 

BL_PI_Direct
BL_NonC
BL_GY_In
BL_ABC_D
BL_NO ABC_D
BL_ABC
BL_No ABC_In
BL_NO_ABC_sw
1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @Sammy22 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1632494657448.png

 

Hope this helps : )

Labels
Top Solution Authors