Filtering not working when no records

Hello, I have a strange situation where my workflow is returning no records from an input (rightly as I am not expecting any records)

but then my filter to only process the records further is still trying to process the data.

I have tried putting a record count in between and filtering where count > 0 but it still ignores the filter

any suggestions

regards

steve

Developer

Accepted answers

BenMoss

I'm not sure I fully understand the problem?

You are filtering data, but then alteryx is still passing zero records through the process after the filter? Yes, this is what Alteryx will do, but it should be pretty quick in doing so, as there is no data.

If you want the workflow to stop running if the count is zero then consider using the TEST tool, and set the condition 'record count matches specific value' and then set the count to be zero.

Ben

All comments

BenMoss

I'm not sure I fully understand the problem?

If you want the workflow to stop running if the count is zero then consider using the TEST tool, and set the condition 'record count matches specific value' and then set the count to be zero.

Ben

MarqueeCrew

@BenMoss,

Testing for 0 records is a trick. Perhaps a use case for a new CReW macro (if you would like to create one). If you test for 0 records, then if 0 records comes through then there is no error.

Cheers,

Mark

AIChudnovsky

Can you provide an example of this?

I'm running a batch macro to read in multiple sheets in an Excel file. If a sheet is empty, it reads zero records and some of the tools error out (e.g., Select Records, Select).

nomulap12

Union a dummy record and then apply the filter.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703