ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Count unique combination of columns

duym314
5 - Atom

Hi there,

 

We have this table

idABCD
1111001
2221101
3331110
4440101

 

We're trying to count the overlapped columns to get this output:

For example: the A to B = 2 *.

IDs 222 and 333 have both A and B products, hence it's 2.

 

And no one has C and D, hence zero, *.

 

 ABCD
A---2 *12
B------12
C---------0*
D------------

 

Thanks for your help!

benakesh
12 - Quasar

Hi @duym314 ,

Transpose and  summarize  produces the expected output. 

benakesh_0-1571874725599.png

 

 

 

duym314
5 - Atom

Thanks so much! Appreciate it!

Labels