Combining Tables and Ensuring Uniqueness by LinkedIn Profile

Goran Popovic

·

How do i combine multiple tables?

6 comments

· Sorted by Oldest

Channeled
APP
·
·
💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!
Daniela Debebs (Clay)
·
·
Hey Goran! Thanks for reaching out. Can you share a bit more info about what you mean by combining multiple tables? If you're referring to merging or adding data from multiple tables into one, you can do this with the write to table feature. Here's a quick guide: https://www.loom.com/share/d46fd74ae9004d229142a2474ac61866?sid=440fafc1-5d4c-4ed4-bebe-449748573397 To ensure all rows are unique, you can dedupe the Linkedin profile urls by clicking on the column header and selecting "dedupe". You can also enable auto-dedupe at the bottom of your table for that column. https://downloads.intercomcdn.com/i/o/1173588642/f303dd9965cd2c86eeffbb0f/CleanShot+2024-09-09+at+12_17_52%402x.png?expires=1725882300&signature=f5a2dfeef2183f5f0c3cf487cf9c67601666bde9574825a5c1eeef2098903726&req=dSEgFcx2lYdbW%2FMW1HO4zfCkPNy8biV2%2B0JxAdhXr%2FtPfBucTOgQHi%2BjA96y%0AWWFo%0A
Goran Popovic
·
·
Thats exactly it.. could you maybe just let me know if deduping works if the linkedin url is not exactly the same?
Goran Popovic
·
·
an example https://www.linkedin.com/company/A and https://www.linkedin.com/company/A/
Daniela Debebs (Clay)
·
·
Hey Goran! Thanks for the reply. The dedupe action uses "exact match" to identify duplicates. To get around this, I recommend using a formula to format the LinkedIn urls to be in the same structure. Here's an example prompt: "If url in {{linkedin url column) ends with "/" remove." Once the urls are formatted to the same structure, the dedupe option will be able to identify true duplicates. Here's a quick guide for using AI formulas: https://www.clay.com/learn/how-to-use-ai-formulas Let me know if this helps. https://downloads.intercomcdn.com/i/o/1173670174/c2b29fe8005fbf380f8fdd6d/CleanShot+2024-09-09+at+13_18_20%402x.png?expires=1725885900&signature=43952a701a415e485f110d6001e32282accbe42110d0b908e26b9f05a1abfc89&req=dSEgFc95nYBYXfMW1HO4zfso0Sv7yk6xHkNeKuex4uP%2FC8jO6EJTK%2FJP5s7m%0AOyLk%0A
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.

Channeled
APP
·
·
💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!
Daniela Debebs (Clay)
·
·
Hey Goran! Thanks for reaching out. Can you share a bit more info about what you mean by combining multiple tables? If you're referring to merging or adding data from multiple tables into one, you can do this with the write to table feature. Here's a quick guide: https://www.loom.com/share/d46fd74ae9004d229142a2474ac61866?sid=440fafc1-5d4c-4ed4-bebe-449748573397 To ensure all rows are unique, you can dedupe the Linkedin profile urls by clicking on the column header and selecting "dedupe". You can also enable auto-dedupe at the bottom of your table for that column. https://downloads.intercomcdn.com/i/o/1173588642/f303dd9965cd2c86eeffbb0f/CleanShot+2024-09-09+at+12_17_52%402x.png?expires=1725882300&signature=f5a2dfeef2183f5f0c3cf487cf9c67601666bde9574825a5c1eeef2098903726&req=dSEgFcx2lYdbW%2FMW1HO4zfCkPNy8biV2%2B0JxAdhXr%2FtPfBucTOgQHi%2BjA96y%0AWWFo%0A
Goran Popovic
·
·
Thats exactly it.. could you maybe just let me know if deduping works if the linkedin url is not exactly the same?
Goran Popovic
·
·
an example https://www.linkedin.com/company/A and https://www.linkedin.com/company/A/
Daniela Debebs (Clay)
·
·
Hey Goran! Thanks for the reply. The dedupe action uses "exact match" to identify duplicates. To get around this, I recommend using a formula to format the LinkedIn urls to be in the same structure. Here's an example prompt: "If url in {{linkedin url column) ends with "/" remove." Once the urls are formatted to the same structure, the dedupe option will be able to identify true duplicates. Here's a quick guide for using AI formulas: https://www.clay.com/learn/how-to-use-ai-formulas Let me know if this helps. https://downloads.intercomcdn.com/i/o/1173670174/c2b29fe8005fbf380f8fdd6d/CleanShot+2024-09-09+at+13_18_20%402x.png?expires=1725885900&signature=43952a701a415e485f110d6001e32282accbe42110d0b908e26b9f05a1abfc89&req=dSEgFc95nYBYXfMW1HO4zfso0Sv7yk6xHkNeKuex4uP%2FC8jO6EJTK%2FJP5s7m%0AOyLk%0A
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.