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
Learn Clay here
Clay Cup

Powered by Tightknit

Troubleshooting Lookup Issues for Multiple Rows in Database Queries

·Nov 03, 2025 11:56 AM·

when running lookup multiple rows in other table I dont have options to search on another table

6 comments

· Sorted by Oldest

Clay Support
APP
·
·
To use "Lookup Multiple Rows in Other Table," you need to select the Table to Search from the dropdown in the action inputs. [1]
The required inputs are:
Table to Search (select your target table)
Target Column (column to search in)
Filter Operator
Row Value (what to search for) [2]
If you're not seeing table options, click into the specific cell where you're setting this up to see if there are any error details that might explain why tables aren't appearing.
Clay Support
APP
·
·
Is that what you were looking for?
Martin B.
·
·
i have no options found at the table to search input
Clay Support
APP
·
·
If no tables appear in the "Table to Search" dropdown, this could be due to the 10-table connection limit across workbooks. [1]
Click into the specific cell where you're setting up the lookup to see if there are error details explaining why tables aren't appearing.
Also ensure you have a Clay API key configured in Settings > Account > API key, as this is required for lookup actions. [2]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help resolving the issue with the "Table to Search" input, I’m here to assist you further. Would you like to provide more details about what you’re trying to achieve or any specific errors you’re encountering?