cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Command list for custom filters

SOLVED
Highlighted
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. 

Alteryx Certified Partner

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

Bolide

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

Alteryx Certified Partner
@ivoller

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