Command list for custom filters

[horizon]

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. 

[LordNeilLord · Accepted solution]

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

[ivoller · Accepted solution]

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.

Cheers,

Iain

[LordNeilLord]

@ivoller

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