Stopping a part of Workflow when a condition fails

I am working on a workflow with 2 streams that are populating 2 different tables. I want to stop one stream if there is no data for the first table but do not want to stop the other part populating the the second table.

I tried using test tool but that stopped the whole workflow and second table was also not populated. Is there any better way to do this?

Workflow

Accepted answers

All comments

jdunkerley79

Interesting challenge. You could do something using a block until done tool.

The outputs of this are sequenced so you could ensure the table you want to write to is attached on output 1

The one that should conditionally be written to could be after a test tool on output 2.

prachigupta93

The only issue in this approach is as the test tool is between the workflow, as soon as that fails the workflow stops even before it reaches to the output tools.

Suppu

Is there any solution for the problem in Version: 2023?

aatalai

use the test tool to create a test if the number of rows is not zero (you will need to use a count records tool and then set it to not equal to zero) and then set on your workflow stop if error

cancel on error.PNG

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703