Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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