File Always Being Written Regardless of the Filter

Question

I am trying to add a branch to my alteryx workflow that writes out a file only if the results of a predecessor step [a record count] equals 0. But for some reason it ALWAYS writes out the file regardless of the predecessor results. The branch is illustrated n the attached. I have a filter at the beginning of the branch that should block the creation of the file when the record count is NOT 0, but it doesn't matter. It ignores the filter and always write out a file. Any help would be GREATLY appreciated. Thanks.

empty file process.docx

afv2688 · Accepted Answer

Hello @artzee1556 ,

I have created a little workflow that simulates what I think is what you desire. Using a batch macro, you can select if you either want the records to be written or not, depending on the row counter:

Its the same macro. As you can see, the one that has rows (1 row), will have no output.

On the other hand, the one that has 0 rows will output the file.

Hope it helps 🙂

Regards

artzee1556 · Accepted Answer

Hello afv2688 -

Sorry I did not get back to you earlier. I have been slammed and FINALLY got a chance to look at your solution today. IT WORKS PERFECTLY. Thanks so much for the xtra brain sweat and for helping me out with this. It has been a challenge to me for months! Sincerely, Art