Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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