Free Trial

Alteryx Designer Desktop Discussions

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

Filter not behaving as expected

kirthig
5 - Atom

Post filter I have 2 dynamic input query to replace a variable each for T and F anchors.

 

Require suggestions to stop executing filter pipeline when condition is not satisfied.

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @kirthig 

 

Can you provide more info on the usecase and some sample data.

kirthig
5 - Atom

kirthig_0-1628603229731.png

In the above snapshot, 2 dynamic input queries are with sql statement (select 'v_parameter' from sys.tables ) where v_parameter is replaced with field1.

When Filter condition is satisfied: Dynamic query of T anchor is executed properly

When Filter condition is not satisfied: Dynamic query of F anchor provides the below error where ideally it should not get executed:

kirthig_1-1628603403127.png

 

HomesickSurfer
12 - Quasar

Hi @kirthig 

 

Use and config a Test tool expression to stop passing records downstream into the second dynamic input.

 

Capture.PNG

atcodedog05
22 - Nova
22 - Nova

Hi @kirthig 

 

Even though you are getting error in false datastream. Your True data stream should not be impacted and should run successfully and completely.

Labels
Top Solution Authors