duplicate data, need to keep oldest date

Question

I have a large amount of data that is repeated and I want to use Alteryx to remove the duplicates but my skills are still very new.  Can someone please help guide me - I have six columns of data and if they match other rows, I want to delete all dates except for the first occurrence (oldest).

I want to keep the rows with 7/7/2021 and delete 7/14/2021 and 7/28/2021.  Pretty simple, right?!! 🙂  Thanks!!

AYX duplicate example.xlsx

HomesickSurfer · Answer

Hi @LRC

Use summary tool, configure as below

atcodedog05 · Answer

Hi @LRC

Here is couple of ways you can do it.

Workflow:

Method - 1. Using unique tool to keep first occurence.

Method - 2. Using sample tool to keep first row of the group.

Method - 3. Using summarize to get first row of group.

Hope this helps : )

messi007 · Answer

@LRC,

a unique tool will do the job for you 🙂

Please see below

Hope this helps!

Attached the workflow.

Regards,

Unique_20210813.yxmd