Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Summarize tool

AS
8 - Asteroid

Need to Calculate distinct Count of code against doc id.

 

Doc IdCodeDistinct count
876901-1
877002-2
877001-2
877001-2
877405-1
878002-3
878009-3
878001-3
878001-3
116003-5
116003-5
116009-5
116009-5
116009-5
116002-5
116002-5
116001-5
116002-5
116001-5
116002-5
116005-5
1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @AS 

 

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

 

Workflow:

atcodedog05_0-1626185458855.png

 

Hope this helps : )

Labels
Top Solution Authors