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

How to stop output when no records

cmStuhl
7 - Meteor

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!

 

 

 

 

3 REPLIES 3
ChrisTX
16 - Nebula
16 - Nebula
Maskell_Rascal
13 - Pulsar

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. 

Maskell_Rascal_1-1660847801285.png

 

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

 

Maskell_Rascal_2-1660847891904.png

 

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
7 - Meteor

This worked! Thank You!

Labels
Top Solution Authors