Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Clay Cup

Powered by Tightknit

Investigating Lookup Bug Between Table 3 and Table 1 | Clay

Investigating Lookup Bug Between Table 3 and Table 1

·May 02, 2025 05:09 PM·

we are performing a "lookup multiple rows in other table" from Table 3 to Table 1 here: https://app.clay.com/workspaces/502615/workbooks/wb_atFzkrA3D4Zh/tables/t_0svfyedkwPEJ884YPSe/views/gv_0svfyed4VVmR7XtsBis I marked a column in red in Table 3 which shows 0 matches - must be a bug as it should be an exact match across at least 100+ rows. Can you please check the bugs & advise how me and Deon M. can fix it?

7 comments

· Sorted by Oldest

Channeled
APP
·
·
The "Lookup Multiple Rows in Other Table" action can only use one column at a time to filter and search for matches. To troubleshoot the issue: 1. Verify that you've selected the correct target column in Table 1. 2. Ensure the filter operator is appropriate for your data. 3. Check that the row values in Table 3 exactly match the target column in Table 1. 4. Consider any data formatting differences (e.g., capitalization, spaces). If the problem persists, you may need to review your data for inconsistencies or try using a different column for matching. If you need further assistance, please request human support by clicking on "Talk to a person" in this chat.
Source: Lookup Rows | Documentation | Clay University
Deon M.
·
·
no
Deon M.
·
·
https://app.clay.com/workspaces/502615/workbooks/wb_atFzkrA3D4Zh/tables/t_0svfyedkwPEJ884YPSe/views/gv_0svfyed4VVmR7XtsBis
Tanvi R.
·
·
Hi Tim, thanks for reaching out! It looks like there are at least 115 rows where the lookup has found a match so it looks like this column is working. Let me know if you're seeing anything that should be different.
(79 kB)
Deon M.
·
·
Tanvi R. 🙌
Tanvi R.
·
·
Hey Tim, yes you can! Simply click on a cell that has results from the lookup and you can add each field returned to a new column.
Deon M.
·
·
Tanvi R. Thanks for your assistance. I think I see what’s going on here.