How to do a count in Knime to cluster frequent buyers

SOmebody knows how to calculate like this using knime:


Customer/ months
January Feb March
A 23 25 23
B 12
C 12 3

Expected Knime calculation results (Count each time with a number in each line)

A 3
B 1
C 2


Welcome to the forum @dataman

The Column Aggregator node is what I’d use for this. On the “Columns” tab you select all the columns you’re interested in. On the “Options” tab you’d select Count and then deselect “Missing”.


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