ouput file only if there are records

Hi all,

I'm using output csv file to provide the data steward with a quick view on any missing mappings etc... So in the flow I have a branch with conditionals and aggregators to identify erroneous/missing values, then output that to csv on a designated place. The data steward reviews these files and knows what to do.

However, the csv is generated even when there are no records. Is there a way to prevent creating the empty csv ?

Thanks!

kind regards

Jay

Output

Accepted answers

Claje

I just wanted to add on a little more to @MarqueeCrew's answer.

If you set up a formula with a filename, and modify your output data tool to "Take file/Table name from field", then if there are no records passed through, alteryx will not create any files. That should skip the need for a "required data element", based on your use case.

Basically, I think you could modify step 1 of the prior answer to a Formula of

'FileName.csv'

based on your example

All comments

MarqueeCrew

Hey @Jay45,

How about this:

Use a FORMULA to create a "filename" field.
```
if IsNull([Required Data Element]) THEN '' ELSE 'FileName.csv' Endif
```
if a required field is NULL, then put blank in filename otherwise use your filename (could be a constant).
Output using "Take File/Table Name" and remove the field from your output

If the name is blank, Alteryx won't output.

Cheers,

Mark

Dont output if empty.yxmd

Claje

I just wanted to add on a little more to @MarqueeCrew's answer.

'FileName.csv'

based on your example

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703