How to Deduplicate Two Lists of Companies Effectively

·

Hello ! I have two lists of companies and I would like to deduplicate them. How can I do this? For example: On one list, it appears as SARL BOB, and on the other list, it appears as just BOB. Basically, I want to do a V lookup with AI, like in Google Sheets, because the company names in the two tables are not necessarily identical. How would you do it?

🎫

1

5 comments

· Sorted by Oldest

Scarlett M.
·
·
Hi - Tom B. You need to add some keywords on clay
Scarlett M.
·
·
If you want then I'll do this for you just DM me.
Tom B.
·
·
If someone else has advices
Sahil H.
·
·
You need a unique identifier look up
Sahil H.
·
·
like linkedin profile maybe

Scarlett M.
·
·
Hi - Tom B. You need to add some keywords on clay
Scarlett M.
·
·
If you want then I'll do this for you just DM me.
Tom B.
·
·
If someone else has advices
Sahil H.
·
·
You need a unique identifier look up
Sahil H.
·
·
like linkedin profile maybe