Startswith and Endswith
https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Filter/ta-p/85764
//note they're case insensitive unless you use 0 as the third argument
startswith([ID],"pc") ||
endswith(ID,"sc")
Custom
=
True
fixed
2019-03-01 11:52:16
0
2019-03-01 11:52:16
2019-03-01 11:52:16
//note they're case insensitive unless you use 0 as the third argument
startswit...
Pc1
PC2
pc3
sc1
SC2
Sc3
1pc
2PC
3Pc
1SC
2sc
3Sc
dog
cat
horse
elephant
tiger
lion
bear
//use the In function instead of = OR
//equivalent to Field1 ="dog" or Field1 = "cat"
[Field1] IN("dog","cat")
Custom
=
True
fixed
2019-03-01 12:00:53
0
2019-03-01 12:00:53
2019-03-01 12:00:53
//use the In function instead of = OR
//equivalent to Field1 ="dog" or Field1 =...
Use the IN function
Know your boolean operators
1
10
2
9
3
8
4
7
5
6
6
5
7
4
8
3
9
2
10
1
//AND and && are the same
[Field1]>1 && [Field1]<9 AND 1=1
Custom
=
True
fixed
2019-03-01 12:21:02
0
2019-03-01 12:21:02
2019-03-01 12:21:02
//AND and && are the same
[Field1]>1 && [Field1]<9 AND 1=1
//NOT and ! are the same
!([Field1]=5) AND NOT ([Field2]=5)
Custom
=
True
fixed
2019-03-01 12:21:02
0
2019-03-01 12:21:02
2019-03-01 12:21:02
//NOT and ! are the same
!([Field1]=5) AND NOT ([Field2]=5)
//OR and || are the same
[Field1]>9 || [Field2]>9 || 1=2
Custom
=
True
fixed
2019-03-01 12:21:02
0
2019-03-01 12:21:02
2019-03-01 12:21:02
//OR and || are the same
[Field1]>9 || [Field2]>9 || 1=2
Vertical
Filter-Digan