How to show only the value for the maximum program for each country

Hi, I need your help because I would like to show in this table the program for each country which has the maximum value. Only one program (with the maximum value) for each country.

How can I do that?
With group by it does not work because I obtain the above picture but I do not obtain the maximum program for each country.

Thanks in advance
Giada

Hi @giad,

use the rank node and then filter for the ranks you want (in your case Top1)

https://hub.knime.com/knime/spaces/Examples/latest/02_ETL_Data_Manipulation/02_Aggregations/04_Generating_a_Ranking_value

2 Likes

Hi @giad,
you can first use group by to determine the max activity for each country. In a second step you join these results to your inital table using inner join method and as key columns country and activity or rather max(activity).

BR
Hermann

2 Likes

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