How to Deduplicate Company Names in Clay Table for Efficient Scanning

Hi on this table ive created a claygent prompt to scan if the company manufactures their own products, its pretty accurate so all good, however i want to run it for the remainder of the table, but dont want to waste credits doing it for duplicate company names. I cant find a way to deduplicate company names any idea what i can do?

4 comments

Daniel G.
·
·
Hi Barry H., I'm sorry but I can't think of any useful way to do it. I had a similar problem the other day and ended up making a checkbox column and selecting unique companies by hand, even if it's not the most efficient way.... Anyway I find the prompt you used interesting, could you share it on this thread please?
Andreas W.
·
·
Hey Barry, can’t see your table ofc, but have you seen the de-dupe feature? cc Daniel G.
Barry H.
·
·
Daniel G. thanks for the heads up re the check box good idea ill pick some of the best ones on that can help me enrich the best ones and use the rest as back up, as for the prompt this is what i used manually checked a bunch and was spot on
1
Barry H.
·
·
thanks Andreas W. yes ive seen this, but on the main company table column as per the image only lets me do duplicate. i also tried on the website to get rid of duplicates but has me get rid of so many contacts Perhaps i can do that, then do the enrichment for claygent then bring them all back again (without enriching the ones i dont need)