No Output File if data not found ( without any error )

Hi,

Greetings !

I have multiple workflows and will have various output files.
However, I do not want any output if there's no data ( table only contain header name ) :

There is a discussion on the community as below :
Solved: Don't Output if No Records - Alteryx Community

However, the steps given will show error ( red color ) when we run it.
Is there any other possible way to ignore blank data ?

Thank you in advance !

Tips and Tricks

Preparation

Accepted answers

Hi @Yoshiro_Fujimori ,

Thank you for your suggestion.
I do not mind any output file type.

For your answer, the result will show all column with value under similar table.
I would like to have various output - workbooks, but ignoring non value data.

I think I got it already, I will just share what I found out, during my development.
I have added a formula tool with new 'FilePath' column, and the setting for output tool as below :

Please let me know if you have any comment / suggestion.
Thank you so much !

All comments

Yoshiro_Fujimori

What is the format of your output files? (.xlsx, .csv, ...)

Yoshiro_Fujimori

Hi @fikrizahari ,

Assuming it's a csv format, I created a potential solution.

(I know this is not so elegant. There may be better ways to prepare the empty data...)

Input

In this case, I want to output a file for each 10's range.

Expected File names

... but the expected File names are from 10's to 70's. So 30's, 60's and 70's should output no record.

Workflow

Output file with no data ("30's.csv")

Messages

I hope this may be of some help.

Good luck.

NoRowsNoOutput.yxmd

Hi @Yoshiro_Fujimori ,

Thank you for your suggestion.
I do not mind any output file type.

For your answer, the result will show all column with value under similar table.
I would like to have various output - workbooks, but ignoring non value data.

I think I got it already, I will just share what I found out, during my development.
I have added a formula tool with new 'FilePath' column, and the setting for output tool as below :

Please let me know if you have any comment / suggestion.
Thank you so much !

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703