Find most common string across columns

[mac95]

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:

becomes:

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!

[ArjenEX]

Hi @mac95

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

How to clear the symbol

Tip for next time: since this query is unrelated to the first question it’s recommended to create a new topic. Regarding your question, use a Column Aggregator and select Mode as aggregation method. [image]

[mac95]

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