Combining Tables and Ensuring Uniqueness by LinkedIn Profile

💤 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!

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

Thats exactly it.. could you maybe just let me know if deduping works if the linkedin url is not exactly the same?

an example https://www.linkedin.com/company/A and https://www.linkedin.com/company/A/

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

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.