preSQL statement in Alteryx output

[Shaaz]

Hi,

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.

[BenMoss · Accepted solution]

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

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Stop-workflow-on-a-condition/ta-p/19890

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


Ben

[Shaaz]

Thanks for such a quick response.

[BenMoss]

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

Ben

[Shaaz]

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 ?

[BenMoss]

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.

Ben