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

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels