How to stop output when no records

[cmStuhl]

Hi!

I have a workflow with several outputs, and several of these outputs can be empty (no records).

How I can stop the output(s) where I have no record, and allowing at the same time the creation of the other outputs where there is at least one record?

If it helps, my input is a .txt and output(s) are .csv

Thanks a lot!

[ChrisTX]

See if this post from yesterday helps:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Stop-a-process-when-there-are-data-in-...

[Maskell_Rascal · Accepted solution]

Hi @cmStuhl 

Here is how you can do it, but it does require a bit of setup. 

You will first need to create a column in your data called FILENAME. This will be used to dynamically name your output file. 

Then configure your Output tool to take the file/table name from the field you created like this:

If there is no data, then the FILENAME field will be blank and the output tool won't write any file. 

Attached is a sample workflow for you to try. The outputs are dynamically pathed, so you can run this and see the results in the folder you save the workflow to. 

Let me know if this helps. 

Cheers!

Phil

[cmStuhl]

This worked! Thank You!