Count number of unique rows within a group

[beperron]

Greetings:

Still new to Alteryx and just ran a deduplication procedure -- impressive functionality.  The output I receive gives me a grouping ID and a key.  How do I count the number of unique keys for each group?  I have been playing with the summarize tool but I am not able to figure out how to do it for groups.

Thanks!

Brian

[scottj · Accepted solution]

In the Summarize tool, use the Group by function for the Group field and the Count Distinct function for the Key.

[beperron]

Got it - thx!

[jdunkerley79]

Use a summarise tool.

You can group by group and then count distinct keys

[HelloGan]

I have the same question. but instead my data set has no key and I want to get the count for a group combination. Is there some out of box I can use?

Thanks!

[JennHall]

I've been looking for this all morning, perfect, thanks!

[JTSJr]

I have the same question.  I have used a name as a sort, but I also need the number of times that each name appears in the report.  Count does not work, Count Distinct does not work.  Any other suggestions?