Count number of unique rows within a group

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

Preparation

Accepted answers

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

All comments

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

Got it - thx!

Use a summarise tool.

You can group by group and then count distinct keys

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!

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15878

MarqueeCrew 13708

apathetichell 13703