Matrix view


I have a table like this:

Class Code
A 001
A 002
A 003
B 001


And I would like to create a symmetric matrix to count the number of times a Code is present in each class:


  A B
A 3 1
B 1 2

In this example only the code 001 is present 1 time at the same time in the Class A and B.

May I kindly ask you what is the fastest way to create this matrix?

Thanks in advance




I have a solution but it might be time consuming for very big data sets. I use a joiner on the code column and afterwards the Scorer generates me the confusion matrix.

Please see the attached workflow.

Best, Iris 

1 Like

Thank you very much. Very nice solution!