Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

output based on a condition - multiple outputs in workflow

shusband
5 - Atom

I have developed a workflow which generates four different output files. I want to ensure that if one of the outputs has no data, it will not generate an output file.

 

Using the test function to check if there is any data, and setting the runtime configuration to 'cancel running workflow on error' does ensure that the output file is not generated - however it also stops the other files which would have contained data being generated. I need to ensure that the files which have data are always written; only the file with no data should not be written.

 

Is there a way to use tool containers, so that if the test fails, it will stop the workflow only for that container? Or is there another way to stop the output of files with no data, so I am not stopping the workflow?

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @shusband have a look at this post you can do this little trick using a Null column to stop a output being created.

shusband
5 - Atom

it works, thanks very much

Labels
Top Solution Authors