Summarize tool

Question

Hi,

I have a workflow to count number of inspections and fails and I run it every week. I'm using summarize tool to count the id's. I just noticed that if there is no data then summarize tool is not taking the count as 0 and no output is written. Just wondering if there is way to use summarize tool to output the number of records as is if any data is there or output as 0 if no data? I already tried count records tool to do this but my team wants me to use summarize tool and do the count. Thanks in advance.

Expected output

Count of Inspections                   Count of Fails

10,000                                               0

atcodedog05 · Answer

Hi @aparna0208

A slightly different way of doing it. I am using Join multiple tool which by default does an outer join.

Hope this helps : )

Inspection.yxmd

Qiu · Answer

@aparna0208 
I guess the Summarize tool itself can not do as you want.

But if you accept some workaround.

New Workflow1.yxmd