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

[fikrizahari]

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 !

[Yoshiro_Fujimori]

@fikrizahari ,

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.

[fikrizahari · Accepted solution]

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 !