Clay Icon

Lost Feature: Lookup Multiple Rows in Same Clay Table

Β·
Β·

The ability to lookup within the same Clay table has been taken away. Earlier we were able to use the enrichment "Lookup Multiple Rows in Other Table" within the same table. This allowed a way to determine the lines which had values which were unique. For example - I could identify if the Company Domain contained one instance of the domain - "cgi.com" or multiple. Sometime ago, it seems like that feature was taken away.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    We apologize for the confusion, but the "Lookup Multiple Rows in Other Table" feature hasn't been removed. It's still available and can be used within the same table. To identify unique values or count instances of a domain, you can use this feature to scan a column for specific values like company domains. This allows you to count how many cells match a particular value, even within the same table. For example, to check for multiple instances of "http://cgi.com", you would: 1. Use "Lookup Multiple Rows in Other Table" 2. Select your current table as the "Table to Search" 3. Choose the domain column as the "Target Column" 4. Set the "Filter Operator" and "Row Value" accordingly 5. Optionally, set a "Limit" for the number of rows to return If you're still experiencing issues, please request human assistance by clicking on "Talk to a person" for further support.

  • Avatar of LuisArturo
    LuisArturo
    Β·
    Β·

    Hey there Siddhant thanks for reaching out, sorry for the long delay here, do you mind sharing the workspace where you are seeing this? This feature has not been removed from Clay so want to check and see what may be going on here.

  • Avatar of Bhavesh T.
    Bhavesh T.
    Β·
    Β·

    Clay S. +1, facing the same issue with two of my Clay accounts, I can't find Lookup enrichment in any of the Clay accounts.

  • Avatar of LuisArturo
    LuisArturo
    Β·
    Β·

    Hey there Bhavesh, do you mind sending the link (url) to the table so we can take a look?

    (52 kB)
    Image
  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·