Alteryx Designer Desktop Discussions

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

New to Alteryx - Filtering Issues

Groffia
5 - Atom

I am killing myself over something so simple.  I need to filter for multiple variables from a single field.  I'm Excel minded right now, so I'm just hoping to select the variables I am looking for in a specific column and the results will filter for me. 

 

Material Movement Type Code - I need to filter for the following codes:  101, 641, 941, 947

 

The basic function in a custom filter won't work: [Mtrl_Mvmnt_Typ_Cd] = ("101","641","941","947")

 

So what will work?  Any help would be greatly appreciated in my adolescent Alteryx state.

 

Thanks, Steve

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus

@Groffia,

 

Don't JUMP!  The solution is ....  IN

 

[Mtrl_Mvmnt_Typ_Cd] IN ("101","641","941","947")

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels