Hi. I have a dataset that contains duplicate values, but also contains date values. I'd like to remove only the oldest duplicate and keep the most recent version. For example: Soccer 1/5/20Baseball1/9/20Baseball1/6/20Soccer1/20/20 In the above example dataset, I'd like to keep: Baseball1/9/20Soccer1/20/20 Thank you!

Alteryx Academy
MyAlteryx
Knowledge
Help Docs

Home
Participate
Discussions
Alteryx One

Removing the oldest duplicate

Hi. I have a dataset that contains duplicate values, but also contains date values. I'd like to remove only the oldest duplicate and keep the most recent version. For example:

Soccer	1/5/20
Baseball	1/9/20
Baseball	1/6/20
Soccer	1/20/20

In the above example dataset, I'd like to keep:

Baseball	1/9/20
Soccer	1/20/20

Thank you!

Data Investigation

Accepted answers

DavidP

This is how I would do it

keep newest.yxmd

AbhilashR

Hi @ajquinones, if you have more than one duplicate/date for a given item (i.e. soccer, baseball) the attached approach might help.

sample.yxmd

All comments

DavidP

This is how I would do it

keep newest.yxmd

AbhilashR

Hi @ajquinones, if you have more than one duplicate/date for a given item (i.e. soccer, baseball) the attached approach might help.

sample.yxmd

ajquinones

Thanks so much!

martinme8

I used this method.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703