Field Missing in Summarize Tool Error

[Dheeru28]

Hi All,

I have a workflow where I'm using Summarize to Group by one field and taking a count of other field.

In the attached example, if there was no record in Field 1 then there would be no Field 1 to group by in summarize tool and it would show an error.

In my actual workflow, it's giving the output. But what I want is Field 1 should also appear with count of 0 in the output.

I hope I am making sense. Please let me know if there is a way to do it?

Thanks!!

[gawa · Accepted solution]

hi @Dheeru28 

Here you go.

Added one Filter tool, having expression 1!=1 always return "false", that never pass any record. By doing this, the schema of Input data is preserved even after Union tool.

[Dheeru28]

Thanks a lot!! @gawa. It works. Just one more thing, if the column that was missing in one week appeared in the data for the next week, then will this filter still work correctly? And, will it work for more than one column?

[gawa]

hi @Dheeru28 

This additional Filter tool always maintain all of fields of input data, even if you use another dataset having different schema.