We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

In Customer Filter 1=2?

rohit782192
11 - Bolide

Sometimes we put 1=2 in Custom Filter. What it Exactly meaning in Logic.

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@rohit782192 
It is a very interesting topic, and I am not sure 😁

TimN
13 - Pulsar

Hi,

I've seen and done this in SQL, particularly Dynamic Input tool.  This is done there because it's just a template for the tool initialization and "1 = 2" string will be replaced at runtime.  If replacement doesn't occur then there won't be any rows returned because 1 = 2 is always false.  If you're putting this in a filter tool then you're guaranteeing False.

Labels
Top Solution Authors