Alteryx Designer Discussions

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

Filtering out customer numbers using filter tool

MATTHEW_KING1
8 - Asteroid

Hi, i need to filter out certain customer numbers coming from my input, i believe i used a filter tool previously, but cannot get this to work. Can anyone please assist? I think its possible using NOT IN but i can't remember how :)

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @MATTHEW_KING1 

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

JosephSerpis
16 - Nebula
16 - Nebula

Hi @MATTHEW_KING1 I mocked up some examples when using value Not In using a filter let me know what you think?

MATTHEW_KING1
8 - Asteroid

@atcodedog05 Please see attached. So if i wanted to exclude 12345 and 33556 how would that be achieved using the NOT IN function on the filter tool please? I tried 

[Cust no] NOT IN ("12345")

 

But the formula seems to go invalid once i add the last parentheses.

MATTHEW_KING1_0-1646404838965.png

 

 

atcodedog05
22 - Nova
22 - Nova

Hi @MATTHEW_KING1 

 

Since its not a number don't use quotes like below

 

atcodedog05_0-1646405026509.png

 

Hope this helps : )

 

MATTHEW_KING1
8 - Asteroid

thanks @atcodedog05  and @JosephSerpis 

Labels