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.
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.
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.
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.
Hey there Bhavesh, do you mind sending the link (url) to the table so we can take a look?