Optimizing Claygent for Duplicate Company Data in LMS Scraping | Clay

Optimizing Claygent for Duplicate Company Data in LMS Scraping | Clay

Muhammad
·
·
One workaround: 1- Create two tables. 2- Do auto-dedupe on the company name column to remove duplicate companies from one table. 3- Once all the duplicate companies are removed, run claygent and map the required data in the columns. 4- In the 2nd table - Do a lookup record to pull the data from the first table where you enriched companies. Not sure if there if this is the best workaround.
Drew Clayton
·
·
If you could give me a simple step by step process. I have an excel spreadsheet with 1465 contacts belonging to 60ish companies. All I want is the LMS value (see screenshot) to populate in the LMS Value Addition field in this table: https://app.clay.com/workspaces/242700/tables/t_rGuGx7jycdu6/views/gv_eT78pCTsUUe4
Drew Clayton
·
·
Loading attachments
Muhammad
·
·
1- Create a 2nd table 2- Copy all the companies from the 1st table(original table containing the companies) to the 2nd table. 3- Dedupe on the company domain to remove duplicate entries in the 2nd table - Now you have a 2nd table with all the unique companies in it. 4- Run the claygent prompt on the 2nd table(containing unique companies) 5- Use lookup single row in other table enrichment in the 1st table and lookup by company domain in the 2nd table 6- Map the results returned by the lookup enrichment. Does this make sense If you follow this step by step should be easy
Drew Clayton
·
·
Thanks Muhammad - I'll give this a whirl tomorrow morning. Might have a chat with you later this week about outsourcing projects.
1
Drew Clayton
·
·
Shall I book on to your calendar?
Muhammad
·
·
sure
1
Bruno (Clay)
·
·
Hey Drew, thanks for reaching out! If you're looking to cache your prompts results, I suggest that you try this lookup + write to table setup which is particularly useful for streaming setups. Here's how you can build this out: https://www.loom.com/share/c90b34abc6f04f848be32fdc861a0d86?sid=5da240cc-c774-4cec-be55-1434f9191a94 I hope this was helpful. If there's anything else I can assist you with, please let me know!
Drew Clayton
·
·
Tried these solutions. Not getting it to work so far. Where I'm up to. I've created two tables. One with company names which is labelled Step 1: https://app.clay.com/workspaces/242700/workbooks/wb_g9wQXp4wSwzi/tables/t_j9miHy9wGnqT/views/gv_T3zWDek2dbTz In row 1, in table 1, you can see from screenshot, we've identified the LMS in the column labelled: "Learning Platforms Used Response". However, as per screenshot in table 2: https://app.clay.com/workspaces/242700/tables/t_rGuGx7jycdu6/views/gv_eT78pCTsUUe4 we are getting no record identified. How do I look up the record and populate all the companies with this value?
Loading attachments
Muhammad
·
·
This should be company domain:
Loading attachments
Muhammad
·
·
This is the value you are trying to find in the other table so it has to be something that is available/common in both tables.
Drew Clayton
·
·
hi mate, like attached?
Loading attachments
Muhammad
·
·
yes sir
Drew Clayton
·
·
thought so. Thanks mate. It's not working. See what Clay support says.
Drew Clayton
·
·
Bruno (Clay) When you're back can you take a look at the tables. Please see why the value is not being pulled through Here are the two tables: https://app.clay.com/workspaces/242700/workbooks/wb_g9wQXp4wSwzi/tables/t_j9miHy9wGnqT/views/gv_T3zWDek2dbTz https://app.clay.com/workspaces/242700/tables/t_rGuGx7jycdu6/views/gv_eT78pCTsUUe4