Find most common string across columns

For each row in my table, I’d like to find the most common value across certain “destination” columns. The result would then appear in another column, “Mode Destination”. So:


KNIME recognises that all columns contain strings.

Using the GroupBy node, I can select the columns I want to use in the Groups tab. I then go into the Manual Aggregation tab, add “Mode Destination”, and set the aggregation operator to Mode.

However, when I run the node, my “Mode Destination” column is blank. What am I doing wrong?

Many thanks!

Hi @mac95

You’re better off with a Column Aggregation node. I posted an example this morning in another topic.


Perfect, thank you! Still quite the newbie to KNIME.

1 Like

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