Troubleshooting Lookup in Multiple Rows Action Errors in Tables

Spencer A. · 2025-08-06T22:06:49.827Z

Can't seem to get the "lookup in multiple rows" action to work. Trying to check if a value in one table appears in another, and keep getting "waterfall step missing attribute path," despite all variables being defined.

8 comments

· Sorted by Oldest

Clay
APP
·
·
The "Lookup Multiple Rows in Other Table" action requires these specific inputs: ** Table to Search ** Target Column ** Filter Operator ** Row Value ** Limit (Optional) The "waterfall step missing attribute path" error suggests one of these required fields isn't properly configured. Double-check that: 1. Your Target Column is correctly selected from the table you're searching 2. Your Row Value references the correct column from your current table 3. The *Filter Operator is set appropriately (equals, contains, etc.) Note that you can only filter using one column at a time with this lookup action. If you need further help troubleshooting the specific configuration, request human assistance by clicking on "Talk to a person."
Sources: Lookup Rows | Documentation | Clay University Lookup Rows | Documentation | Clay University Lookup Rows | Documentation | Clay University Lookup Multiple Rows in Other Table with Clay
Spencer A.
·
·
Those inputs are all linked but I still get the error
Bo (.
·
·
Spencer - Do you mind sending the link (url) to the table so we can take a look?
(52 kB)
Spencer A.
·
·
https://app.clay.com/workspaces/717418/workbooks/wb_0t0jk5hDPCCDA42QAnh/tables/t_0t0jk5h3aurRPjhHskQ/views/gv_0t0jk5iiaAGYVvrBySe
Spencer A.
·
·
I'm gonna be gone for a few hours, let me know if there is any step by step directions I can find that work
Bo (.
·
·
Hey — sounds like you’re trying to use a lookup inside a waterfall step. That won’t work, since lookups aren’t supported within waterfalls. You can run the lookup separately to enrich the data first, and then use the result in your waterfall. Let me know if you need help setting that up.
Spencer A.
·
·
Yeah, I couldn’t find an option to run an action outside of the waterfall, only formulas (very new to clay haha). How do you do it independently?
Bo (.
·
·
Welcome to Clay — glad to have you here! To run the lookup independently from the waterfall: 1. Open the Actions menu at the top of your table 2. Search for “Lookup in multiple rows” and add it as a separate column 3. Once it’s run, go into your Waterfall > Run Settings 4. Set a run condition like “only run if [your lookup column] has a value” That way, the lookup runs first, and your waterfall only triggers if it has data to work with. Here’s a helpful guide too: https://www.clay.com/university/lesson/how-to-use-ai-formulas Let me know if you want help setting it up.

Clay
APP
·
·
The "Lookup Multiple Rows in Other Table" action requires these specific inputs: ** Table to Search ** Target Column ** Filter Operator ** Row Value ** Limit (Optional) The "waterfall step missing attribute path" error suggests one of these required fields isn't properly configured. Double-check that: 1. Your Target Column is correctly selected from the table you're searching 2. Your Row Value references the correct column from your current table 3. The *Filter Operator is set appropriately (equals, contains, etc.) Note that you can only filter using one column at a time with this lookup action. If you need further help troubleshooting the specific configuration, request human assistance by clicking on "Talk to a person."
Sources: Lookup Rows | Documentation | Clay University Lookup Rows | Documentation | Clay University Lookup Rows | Documentation | Clay University Lookup Multiple Rows in Other Table with Clay
Spencer A.
·
·
Those inputs are all linked but I still get the error
Bo (.
·
·
Spencer - Do you mind sending the link (url) to the table so we can take a look?
(52 kB)
Spencer A.
·
·
https://app.clay.com/workspaces/717418/workbooks/wb_0t0jk5hDPCCDA42QAnh/tables/t_0t0jk5h3aurRPjhHskQ/views/gv_0t0jk5iiaAGYVvrBySe
Spencer A.
·
·
I'm gonna be gone for a few hours, let me know if there is any step by step directions I can find that work
Bo (.
·
·
Hey — sounds like you’re trying to use a lookup inside a waterfall step. That won’t work, since lookups aren’t supported within waterfalls. You can run the lookup separately to enrich the data first, and then use the result in your waterfall. Let me know if you need help setting that up.
Spencer A.
·
·
Yeah, I couldn’t find an option to run an action outside of the waterfall, only formulas (very new to clay haha). How do you do it independently?
Bo (.
·
·
Welcome to Clay — glad to have you here! To run the lookup independently from the waterfall: 1. Open the Actions menu at the top of your table 2. Search for “Lookup in multiple rows” and add it as a separate column 3. Once it’s run, go into your Waterfall > Run Settings 4. Set a run condition like “only run if [your lookup column] has a value” That way, the lookup runs first, and your waterfall only triggers if it has data to work with. Here’s a helpful guide too: https://www.clay.com/university/lesson/how-to-use-ai-formulas Let me know if you want help setting it up.