Getting error "New Unique index skipped: Requested columns (colulmn name) on table (customer_account) contain duplicate values. You must remove duplicate values and then try again." while trying to set field to Unique.

[Jayant Balyan1]

Getting error "New Unique index skipped: Requested columns (colulmn name) on table (customer_account) contain duplicate values. You must remove duplicate values and then try again." while trying to set field to Unique. 

I checked the column on that table, it does not have any duplicate value.

[Voona Rohila · Accepted solution]

Hi Jayant

groupby that column you are trying to make unique and verify again if there are any duplicates.