Selecting the top value after sorting

KNIME Analytics Platform
1

Hi Guys,

I am sorting a column in descending order and I need to use the first value of the sorted row as a condition in the Rule engine node.I am sorting the data by a column Month1 using sorter and I need to check each values of other column Month2 if it is less than
the top value of Month1.Could you please let me know how to do this. Hypothetically the expression in my rule engine should be

$Month$ < $Current_Month$[1] =>$Month$

But not sure how to find Current_Month$[1]

2

Hi,

I think you could use the GroupBy node first, and aggregate on Month1 (max) to determine the highest value of Month1, and then use this in the Rule Engne to see if Month2 is smaller than Month1(max).

Hope this helps you forward/Evert