How can I use summarize tool, if the input of summarize is empty?

My sub-workflow is shown like below:

After filtering, the output could be nothing. Then I use a summarize tool to count how many rows in the output, the tool also give me nothing (I need a zero or null here), if there is not data after filtering!!!! This is a big problem, since I do need to check whether there is output for this filter class.

Is there a way to do summarize (or other equivalent way) after empty data set?

Output

Accepted answers

unknown

Use the count records macro beside it in the Transform palette, that will always give you a count value, even a count value of 0 if there is no records (it will create a record)

All comments

unknown

Use the count records macro beside it in the Transform palette, that will always give you a count value, even a count value of 0 if there is no records (it will create a record)

diabolic

Hi, what do u mean by "count records macro"? Is it a tool in Alteryx? Could you give me a screenshot?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703