Fuzzy match rows within the same table

[gk2go]

I have this table:

URL                             | Date         | Type

example.com/victims  | 1/1/2011  | A

example.com/victums | 2/2/2022  | B

example.com/victim    | 3/3/2033  | C

I would like it to become:

URL                             | Date         | Type

example.com/victims  | 1/1/2011  | A

That is since the URLs are very similar, I want to only keep the one with the earliest Date, the original.

[v-xuding-msft]

Hi @gk2go ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here. If it still doesn't work, please share a dummy file that easier for help.

Best Regards,

Xue

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xuding-msft · Accepted solution]

Hi @gk2go ,

You could use the option of earlist date in values of fields directly.

Best Regards,

Xue

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.