Multicolumn filter and multiple possible answers

Hi All,

I am trying to write a multiple criteria to my filter:
If Column 1 = a and Column 2 = 5 then include or
if Column 1 = b and Column 2 = 5 then include or
if Column 1 = c and column 2 = 6 then include or etc....

Could you please advise what is the best function to use on such filtering and what the Syntax would be?

Thank you for your help, much appreciated.

Michal

Common Use Cases

Accepted answers

MichalJ

i figured it out. It was because cost element is numerical field and for example "60517301" should be written as 60517301. thank you all for your help!

All comments

haroon_sa

Hi @MichalJ

Check out this solution. Hope it helps.

FILTER.yxmd

ivoller

You can use the Custom filter option of the Filter Tool with an expression like

([Column 1] = "a" and [Column 2] = 5) or
([Column 1] = "b" and [Column 2] = 5) or
([Column 1] = "c" and [column 2] = 6)

you could also simplify to

([column 1] in ("a","b") && [column 2] = 5) || ([Column 1] = "c" and [column 2] = 6)

MichalJ

The below is exactly what i am trying to achieve, but getting this message: Parse Error at char (798): Unmatched (

I am not quite sure what is wrong....

([Cost Elem.] = "60517301" AND [Site] = "SKL" OR
[Cost Elem.] = "60512408" AND [Site] = "SKL" OR
[Cost Elem.] = "60512442" AND [Site] = "SKL" OR
[Cost Elem.] = "60517901" AND [Site] = "SKL" OR
[Cost Elem.] = "60517201" AND [Site] = "SKL" OR
[Cost Elem.] = "60516201" AND [Site] = "SKL" OR
[Cost Elem.] = "60516302" AND [Site] = "SKL" OR
[Cost Elem.] = "60516301" AND [Site] = "SKL" OR
[Cost Elem.] = "60512411" AND [Site] = "DR" OR
[Cost Elem.] = "60512411" AND [Site] = "LIT" OR
[Cost Elem.] = "60517301" AND [Site] = "LIT" OR
[Cost Elem.] = "60512410" AND [Site] = "LAP" OR
[Cost Elem.] = "60512411" AND [Site] = "LAP" OR
[Cost Elem.] = "60517301" AND [Site] = "LAP" OR
[Cost Elem.] = "60512408" AND [Site] = "LAP"

ivoller

The expression starts with "(" but there is no ending parenthesis.

ivoller

I always think it helps to put distinct clauses in parenthesis as it helps me to understand what is intended. It looks like your expression could be written as

Re: Multicolumn filter and multiple possible answers (Alteryx Community Subscription Update)

([Cost Elem.] = "60517301" AND [Site] = "SKL") OR
([Cost Elem.] = "60512408" AND [Site] = "SKL") OR
([Cost Elem.] = "60512442" AND [Site] = "SKL") OR
([Cost Elem.] = "60517901" AND [Site] = "SKL") OR
([Cost Elem.] = "60517201" AND [Site] = "SKL") OR
([Cost Elem.] = "60516201" AND [Site] = "SKL") OR
([Cost Elem.] = "60516302" AND [Site] = "SKL") OR
([Cost Elem.] = "60516301" AND [Site] = "SKL") OR
([Cost Elem.] = "60512411" AND [Site] = "DR") OR
([Cost Elem.] = "60512411" AND [Site] = "LIT") OR
([Cost Elem.] = "60517301" AND [Site] = "LIT") OR
([Cost Elem.] = "60512410" AND [Site] = "LAP") OR
([Cost Elem.] = "60512411" AND [Site] = "LAP") OR
([Cost Elem.] = "60517301" AND [Site] = "LAP") OR
([Cost Elem.] = "60512408" AND [Site] = "LAP")

Also it could be simplified by using the IN operator - see above

MichalJ

i figured it out. It was because cost element is numerical field and for example "60517301" should be written as 60517301. thank you all for your help!

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335