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
my needing is to identify the minimum value:
I’ve used Column Comparator, but it’s really uncomfortable with many columns
I also tried to transpose date to something like:
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:
You can also try the “Column Aggregator” node: less coding
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 https://blog.statinfer.com/
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 NodePit.com and you will find a section named “Installation”.
You have to install the required extension.
you can also think about to use the unpivot node and then the group by node.
KNIME offers multiple integrations and extensions. Here you can read more on how to get nodes these extensions
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.