Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! 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
21 - Polaris
21 - Polaris

@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
21 - Polaris
21 - Polaris

Void

 

tanvir_khan
8 - Asteroid

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

 

thanks a lot man!

Qiu
21 - Polaris
21 - Polaris

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

Glad to help.

Labels