New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

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 !