Matrix view

KNIME Analytics Platform
1

Hi,

I have a table like this:

Class Code
A 001
A 002
A 003
B 001
B

005

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

 

 

2

Hi,

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
3

Thank you very much. Very nice solution!