Find rows with duplicate values in certain column

[snakeeyes]

Hello
Is there a way from the console, perhaps using rest queries, to find rows that have duplicate values in a certaon colum.

For exmaple I want to find rows that have duplicate customer name .

Thanks

[mark-piller]

Hello,

This can be done by using grouping with the having clause. For example, here’s my data table:

I want to find all the records with duplicate values in the firstName column. This is the configuration for the query in REST Console:

There are three parts to it:

1. Request a custom property that uses the count function - count(objectId) in my case
2. group by the column where you expect duplicate values
3. use the having clause that references the count value from the first part

REST Console will display the full REST URL in the Where section (not showing the picture).

Regards,
Mark

[snakeeyes]

Awesome . Thank you Mark