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

Filter Condition

arjundelara
8 - Asteroid

Hi All,

 

How can I set the filter of the column that will not equal to the all values of a column.

 

Ex.

   My First Workflow filter is [PTP] != "Japan"

 

The needed update

  [PTP] != All values in a column

 

Thank you!

6 REPLIES 6
atcodedog05
22 - Nova
22 - Nova

Hi @arjundelara 

 

Its bit unclear can you give an example

arjundelara
8 - Asteroid

@atcodedog05 

 

Sorry for the unclear explanation

 

This is my example.

 

My static first filter is this [Field] != "Japan" then the needed update is [Field] != to the [F2] (All values contains in [F2] will not get)

 

arjundelara_0-1605089532441.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @arjundelara 

 

Here is a workflow for the task.

Workflow:

atcodedog05_0-1605089948371.png

 

Basically if Field is not in F2 then it will come in unjoin

 

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

arjundelara
8 - Asteroid

Hi @atcodedog05 

 

It works! 

 

Highly Appreciated 🙂

 

Thank you!

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @arjundelara 

 

Cheers and Happy Analyzing 😀

arjundelara
8 - Asteroid

@atcodedog05 

 

Amazing and Great 🙂

 

Thank you!

 

Have a good day ❤️

Labels
Top Solution Authors