Lookup Multiple Rows with Column Conditions in SQL Tables

is there any way to lookup multiple rows in another table and apply a variety of column value conditions/constraints on that lookup? for example lookup all rows in table X where Column Y equals/contains z AND Column W equals/contains p

👍1

4 comments

Mark L.
·
·
Nir, thanks for getting in touch. Today, there is no ability to do such lookups in Clay. You would need to complete the lookup, return the records as applicable, and then you could "post-process" them depending on the properties in each record. From what I understand, the product decision-makers will be exploring this further in the future. No specific timeline for that. But I did see a recent internal conversation on the same topic, so I've shared your feedback there. We'll evaluate and see what we can squeeze into the future product roadmap – thanks again for sharing this!
👍1
Channeled
APP
·
·
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
Channeled
APP
·
·
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Channeled
APP
·
·
Hi Nir B.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: