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