Cleaning lookup duplicates

Hi Guys,

I was working today with my lookups and I didn't know what is the best way to delete duplicate lookup values. I think that my advices will help you to work with lookups next time. 

So if lookup values are not used yet (don’t have any connections) then you can go to the Lookup section in the interface and delete them one by one. Another variant is to write an SQL script for deleting duplicate lookup values and run it. Below you can find a screenshot of where you can add it.

Advanced settings -> Configuration -> SQL scripts -> Add

If these lookup values have been used in some records already and therefore have connections, you need to delete those connections first and only after that action start deleting lookup values.

Hope this matrial will be helpful. Thank you.