We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

output only when there are enough records in input node

tanvir_khan
8 - Asteroid

Hi:

 

I'd like to extract data and output those in an alteryx db file. I'd like to ensure if there are no records in input, it shouldn't generate output. The output will only be generated if there are more than 5K records for examples. I've tried in many ways like count records and the applied conditional filter node but every time it generates output and whenever there is no record, it generates empty output file.

Any ideas how to do it in Alteryx please?    

 

tanvir_khan_0-1671763825288.png

 

Thanks!

4 REPLIES 4
Qiu
20 - Arcturus
20 - Arcturus

@tanvir_khan 
There is a very nice post here to show how this can be done.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-not-create-output-when-no-recor...
Note that the Excel file output is NOT supported. 

1223-tanvir_khan.PNG

Qiu
20 - Arcturus
20 - Arcturus

Void

 

tanvir_khan
8 - Asteroid

@Qiu that's cheeky, a mesmerising trick with Null. 

 

thanks a lot man!

Qiu
20 - Arcturus
20 - Arcturus

@tanvir_khan 
I happened to notice that post and bookmarked it.

Glad to help.

Labels