Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
RÉSOLU

output based on a condition - multiple outputs in workflow

shusband
Atome

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 RÉPONSES 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
Atome

it works, thanks very much

Étiquettes