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

Command list for custom filters

horizon
5 - Atom

Hello,

 

I am looking for a list that can show what character set can be used to create custom filters. For example when i make a filter upon 2 columns i can use && and OR. Thank you. 

3 REPLIES 3
LordNeilLord
15 - Aurora

Hey @horizon

 

Have a look at this page, it should answer your question:

 

https://help.alteryx.com/9.5/Reference/Functions.htm#Operators_

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

ivoller
12 - Quasar

Great link from @LordNeilLord. Another quick lookup is from the Custom filter | Functions | Operators section of the Filter Tool. I don't know why it's not in the Formula Tool.

 

2018-04-11_15-19-19.png

 

Cheers,

Iain

LordNeilLord
15 - Aurora
@ivoller

I knew I'd seen that in alteryx somewhere but I thought it was in the formula tool!
Labels