Multiple columns comparision

Hi, I’m trying to solve this problem: one simple table with ID and many columns with date values, let me say 5

ID col1 col2 col2 col3 col4 col5
1 date_a date_b date_c date_d date_d date_e
2 …

my needing is to identify the minimum value:

ID min_date
1 xxxx

I’ve used Column Comparator, but it’s really uncomfortable with many columns

I also tried to transpose date to something like:

ID row_values
1 date_a
1 date_b
1 date_c
1 date_d
1 date_e

and then grouping to get (for instance) minimum
but I didn’t find the right NODE to transpose in that way

thanks in advantage for your suggestions

Hi and welcome to the KNIME forum,

Use this node and the “min” function to find the minimum value among the date columns.

Here you can read more about how to use the node:


1 Like

You can also try the “Column Aggregator” node: less coding :slight_smile:


Many thanks Armin and Hans

I tried “Column Aggregator” and it’s really simple and strong! Thank you Hans

I’m also very impressed by “Column Expressions”, thank you Armin for the link…I discovered

Unfortunately I was no able to find the node and/or install it by updating (Knime 3.7 updated every day). How can I get it?

Follow the link I shared at and you will find a section named “Installation”.
You have to install the required extension.


1 Like

you can also think about to use the unpivot node and then the group by node.


1 Like

Hi @mauipm!

KNIME offers multiple integrations and extensions. Here you can read more on how to get nodes these extensions :wink:


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