Retrieve row by maximum value

Solved!
Tib
Level 1
Retrieve row by maximum value

Hello,

I have a dataset containing sevral row like this :

idvrsdata
00233874867335317info1
00233874869487634info2
00233874869000149info3
00240847797405858info4
00240847799633221info5

 

I want to retrieve (filter) the row for each id where we have the greatest vrs value for this id, resulting in :

idvrsdata
00233874869487634info2
00240847799633221info5

 

How can it be done ?

Thank you in advance,

Thibault

1 Solution
Ignacio_Toledo

Hi @Tib 

Here is a video with one way of getting what you are looking for:

https://youtu.be/Ub6NxEYcigI

Hope this helps!

View solution in original post

2 Replies
Ignacio_Toledo

Hi @Tib 

Here is a video with one way of getting what you are looking for:

https://youtu.be/Ub6NxEYcigI

Hope this helps!

View solution in original post

Tib
Level 1
Author

Thank you very much@Ignacio_Toledo !