Clay Icon

How to Check for Duplicates Across Multiple Excel Workbooks

·
·

Probably has been answered already but how can i check if value is already not in another workbook? E.g. a LinkedIn URL of a lead across different workbooks or in a certain other workbook -> essentially removing duplicates.

  • Avatar of Muhammad S.
    Muhammad S.
    ·
    ·

    lookup single row enrichment

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    You have two main options to check for duplicates across workbooks: 1. Use the Lookup feature: • Use "Lookup Single Row in Other Table" to check if a specific record exists in another table • Use "Lookup Multiple Rows in Other Table" for checking multiple rows at once 2. Enable Auto-dedupe: • This feature automatically monitors a specified column for duplicate values • It keeps the oldest row and removes duplicates • To enable it: • Open your table settings dropdown • Click the table dropdown menu and select 'Enable/Disable auto-dedupe' • Toggle it on and select the column to check for duplicates Before running new enrichments, it's recommended to check if the data already exists in another Clay table. If it does, use a Lookup column to pull that existing data into your current table - this helps avoid duplicate enrichments and saves credits.

  • Avatar of Matïss R.
    Matïss R.
    ·
    ·

    How does it work? Does it take a cell value from original table (say /LinkedIn URL) and go through all the values from the other other table and returns something if it exists in the other table?

  • Avatar of Muhammad S.
    Muhammad S.
    ·
    ·

    correct it works like a vlookup in excel

  • Avatar of Muhammad S.
    Muhammad S.
    ·
    ·

    checks a value against a list of values in other table

  • Avatar of Matïss R.
    Matïss R.
    ·
    ·

    I see, thank you. But the output is a bit unclear. If there is nothing in that other table it will output no value if there is a duplicate if will output something?

  • Avatar of Muhammad S.
    Muhammad S.
    ·
    ·

    yes, if it matches the record in other table, it will says 1 record found otherwise no record found

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    The Lookup feature in Clay works similarly to VLOOKUP in Excel, allowing you to search and retrieve data from other tables in your workspace. Here's how it works: You have two lookup options: 1. Lookup Single Row: • Searches for a specific value in another table • Returns only one matching row • Operates faster than multiple row lookup 2. Lookup Multiple Rows: • Searches for all matching instances in another table • Can return multiple matching rows • Includes an optional limit setting to control the number of returned rows For both options, you'll need to specify: ** The table you want to search in ** The target column to search ** The filter operator ** The value you want to look up This functionality helps maintain data consistency and enables connections between different tables in your workspace.

  • Avatar of Matïss R.
    Matïss R.
    ·
    ·

    Muhammad, thank you!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·
  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Thank you so much for sharing your feedback ​Matïss R.​!

  • Avatar of Matïss R.
    Matïss R.
    ·
    ·

    One more question tho - what exactly is the difference between looking up singe row and multiple rows. In my example I want to look if a LinkedIn URL in a cell (in OG table), matches (is equal) to any of the cells (in a certain column) in other table. Is this a single or multiple row lookup?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    For checking if a LinkedIn URL exists in another table, you can use either option, but here are the key differences: 1. Lookup Single Row: • Returns only one matching row • Operates faster than multiple row lookup • Best when you only need to confirm existence of a match 2. Lookup Multiple Rows: • Can find and return all matching instances • Allows you to set a limit on the number of returned rows • Better when you need to see all potential matches For your specific use case of just checking if a LinkedIn URL exists in another table, the Lookup Single Row option would be more efficient since you only need to verify existence rather than retrieve multiple matches.

  • Avatar of Muhammad S.
    Muhammad S.
    ·
    ·

    Single row: Use to check and fetch one record from other table Multple row: Used to fetch all the matching record from other table (upto 100)