GROUP BY

[suby]

Hi,

Attached sample flow with the data need help with the expected Output.

Thanks

[suby]

Attaching the WF.

[DataNath · Accepted solution]

@suby when you do counts in the Summarize tool, there's the option to skip null values and so you'd just want to use that here. Once you've done the counts of both fields, you can just append these back onto the main data set: