Delete records which are having count 2 when grouped

[Akki1]

Hi,

I have a field 'u_custom_key' and when I groupby my records with this field there are records which are having count 2 so I want to delete one of them on the basis of updated field, I want to delete the old one and keep the new one

[Samaksh Wani]

Hello @Akki1 

In your navigation filter, type: sys_user_group_type.list

That will pull up list view of Types. Select the one you want to delete, and use List drop down at bottom and select Delete.

Plz Mark my Solution as Accept and Give me thumbs up, if you find it Helpful.

Regards,

Samaksh

[Akki1]

@Samaksh Wani It has more than 100k records. We cannot manually delete it

[Samaksh Wani]

Hello @Akki1 

Instead of doing Group By, Right Click on the count 2 and select show Matching, it will filter out the records with count 2.

then After filter out click on select all checkbox and delete. it will delete all records.

Plz Mark my Solution as Accept and Give me thumbs up, if you find it Helpful.

Regards,

Samaksh

[Akki1]

@Samaksh Wani This will delete both records I want to keep one