Table Lookup with Combined Filter Values in SQL

Fabian H. · 2025-05-06T14:58:13.140498+00:00

how can I do a table lookup based on 2 filter values combined? customerId == customerId && tenant == tentant for exmaple

To perform a table lookup using two combined filter values in Clay, you can use the "Lookup Multiple Rows in Other Table" action. Here's how: 1. Select the table you want to search in. 2. Choose your first filter column (e.g., "customerId"). 3. Set the filter operator (e.g., "equal to"). 4. Enter the value for the first filter. 5. Add a second filter by selecting the "AND" operator. 6. Choose your second filter column (e.g., "tenant"). 7. Set the filter operator for the second column. 8. Enter the value for the second filter. This will return rows that match both conditions. You can also set a limit on the number of rows returned if needed.

Sources: Lookup Rows | Documentation | Clay University Lookup Rows | Documentation | Clay University

3 comments