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: [image] becomes: [image] 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. [image] How to clear the symbol KNIME Analytics Platform 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]

Find most common string across columns

KNIME Analytics Platform

ArjenEX July 13, 2023, 11:24am 2

Hi @mac95

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

6 Likes