Summarize tool

[AS]

Need to Calculate distinct Count of code against doc id.

Doc Id	Code	Distinct count
8769	01-	1
8770	02-	2
8770	01-	2
8770	01-	2
8774	05-	1
8780	02-	3
8780	09-	3
8780	01-	3
8780	01-	3
1160	03-	5
1160	03-	5
1160	09-	5
1160	09-	5
1160	09-	5
1160	02-	5
1160	02-	5
1160	01-	5
1160	02-	5
1160	01-	5
1160	02-	5
1160	05-	5

[atcodedog05]

Hi @AS 

You can do something like this. Calculate distinct count for Doc ID and joining it back.

Workflow:

Hope this helps : )