How to do a count in Knime to cluster frequent buyers

Hi
SOmebody knows how to calculate like this using knime:

Database

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

Thanks,

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”.

3 Likes