How to stop output when no records

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!

Developer

Developer Tools

Output

Custom Tools

Connectors

Common Use Cases

Accepted answers

Maskell_Rascal

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

Conditional Write File If Data Exists.yxmd

All comments

ChrisTX

See if this post from yesterday helps:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Stop-a-process-when-there-are-data-in-one-part-of-a-Join-and/td-p/984598

Maskell_Rascal

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

Conditional Write File If Data Exists.yxmd

cmStuhl

This worked! Thank You!

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335