Table transformation

How would you transform the table on the left to the right in KNIME.

From excel, I can use countif forumlas based on two criteria but I’m unsure how to do so in KNIME

Hi @lahiru_ten,

based on your example you first have to unpivot your source table keeping system reference and discipline as retained column and unpivot all other colmuns. Next you need to pivot your results using discipline and columnnames column as group condition, columnvalues column as pivot condition and system reference column for aggregation with function count.

BR

6 Likes

Worked perfectly, much appreciated

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.