Retrieve row by maximum value

Options
Tib
Tib Registered Posts: 2 ✭✭✭

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

Best Answer

  • Ignacio_Toledo
    Ignacio_Toledo Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 411 Neuron
    Answer ✓
    Options

    Hi @Tib

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

    https://youtu.be/Ub6NxEYcigI

    Hope this helps!

Answers

Setup Info
    Tags
      Help me…