Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

preSQL statement in Alteryx output

Alteryx Partner


I've developed a simple workflow where in Filter tool, I'll have a condition.


True part will go Table1 output and False part will go Table2 output.


Table2 output has some pre-sql statement.


How do I stop running pre-sql statement in Table2 output if there are no records in False case.



Alteryx Certified Partner
Alteryx Certified Partner

I think you can make use of this post in tandem with the block until done tool.

A configuration like in the below image should help you achieve your goal.

BenTest Dont Write.png

Alteryx Partner

Thanks for such a quick response.

Alteryx Certified Partner
Alteryx Certified Partner

Sorry I actually think it should look more like this! Though I'm sure you got the idea!





Alteryx Partner

Hi, Thanks for this but workflow will stop completely. Suppose in a single workflow I've multiple containers with different business rules,the workflow of other container will not run. How do we tackle this ?

Alteryx Certified Partner
Alteryx Certified Partner

A set-up like this could work.


The append one is perhaps the key one (/strangest one) as you are using the tool to essentially say, 'despite this stream being unrelated I want to process this before it moves onto step two of the block until done'.

In this type of instance you should sample a single line and append this against the data stream you want to transform you would take no records from the 'source' side as you aren't actually interested in this information.