Return All Values from Column in SQL with Multiple Rows

Ciaran E.

·Nov 20, 2025 03:06 PM·

How do I get "Find Multiple Rows in Other Table" to return every value in a column?

6 comments

· Sorted by Oldest

Clay Support
APP
·
·
To return every value in a column using "Find Multiple Rows in Other Table," you need to fill in the Row Value field that's currently empty in your setup.
The action requires these inputs: Table to Search, Target Column, Filter Operator, and Row Value. You can type "/" in the Row Value field to insert a column reference from your current table.
If you want to retrieve all rows without filtering, consider using our built-in AI tool Sculptor in the top-right corner to help set up the optimal workflow for your needs.
Clay Support
APP
·
·
Is that what you were looking for?
Ciaran E.
·
·
could I set the value to contains a,e,i,o,u
Clay Support
APP
·
·
No, you cannot use multiple values like "a,e,i,o,u" in a single Row Value field with the "Contains" operator.
The "Find Multiple Rows in Other Table" action only allows one column at a time to filter with, and you can only use one value per search.
However, you could use the "Contains Any Of" operator instead, which checks if the text contains any value from a list like ["a", "e", "i", "o", "u"].
Alternatively, try using our built-in AI tool Sculptor in the top-right corner to help set up an optimal workflow for your specific filtering needs.
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help setting up your filter or using Sculptor for this task, I’m here to assist. Would you like to provide more details about what you’re trying to achieve so I can support you further?

Clay Support
APP
·
·
To return every value in a column using "Find Multiple Rows in Other Table," you need to fill in the Row Value field that's currently empty in your setup.
The action requires these inputs: Table to Search, Target Column, Filter Operator, and Row Value. You can type "/" in the Row Value field to insert a column reference from your current table.
If you want to retrieve all rows without filtering, consider using our built-in AI tool Sculptor in the top-right corner to help set up the optimal workflow for your needs.
Clay Support
APP
·
·
Is that what you were looking for?
Ciaran E.
·
·
could I set the value to contains a,e,i,o,u
Clay Support
APP
·
·
No, you cannot use multiple values like "a,e,i,o,u" in a single Row Value field with the "Contains" operator.
The "Find Multiple Rows in Other Table" action only allows one column at a time to filter with, and you can only use one value per search.
However, you could use the "Contains Any Of" operator instead, which checks if the text contains any value from a list like ["a", "e", "i", "o", "u"].
Alternatively, try using our built-in AI tool Sculptor in the top-right corner to help set up an optimal workflow for your specific filtering needs.
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help setting up your filter or using Sculptor for this task, I’m here to assist. Would you like to provide more details about what you’re trying to achieve so I can support you further?