Clay doesn't have a built-in waterfall lookup feature for searching across multiple tables, but you can achieve this using our Lookup Rows feature combined with custom waterfalls. [1] [2]
You can use the "Lookup Single Row in Other Table" action to check each of your 11 tables sequentially. Set up a custom waterfall that conditionally runs lookups - if the first table doesn't find your ID, it moves to the next table, and so on.
For checking duplicates across multiple tables, our Lookup integration is specifically designed for this use case.
Try using Sculptor (top-right corner) to help build this workflow quickly - it can generate the setup for you automatically.
If you need any more help setting up your waterfall lookup or using Sculptor, I’m here to assist. Would you like to share more details about what you’re trying to achieve so we can continue?
If you need any further assistance with creating your custom waterfall or using Sculptor, I’m here to help. Would you like to provide more details about what you’re trying to accomplish so we can continue?
The "No properties" message usually means there are no items published with that field or the lookup hasn't found any matching data yet.
Try running the lookup first to see if it finds data, then the output options should populate. If you're still stuck, I'd recommend trying Sculptor (top-right corner) - it can help build this waterfall workflow automatically and might resolve the configuration issue.
You can also create child columns from enrichment results by clicking on a cell with data and selecting "Add as column" for specific endpoints. [1]
If you still need help with setting the output for your waterfall or using Sculptor, I’m here to assist. Would you like to share more about the specific issue you’re encountering so we can continue?
