Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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
17 - Castor
17 - Castor

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