Using If This Then That Logic to Connect Two Tables in a Database

·Jun 30, 2025 08:31 PM·

can I do "if this then that" logic in a column. For example, I have 2 tables. One with contractors location and another with job location. Can table 1 pull data from table 2 based on table 1 variable?

1 comment

· Sorted by Oldest

Clay
APP
·
·
You can use the Lookup feature in Clay to pull data from one table to another based on variables. There are two options: 1. Lookup Single Row in Other Table - For retrieving one matching row (faster performance) • Select the table to search • Specify target column • Choose filter operator • Set row value 2. Lookup Multiple Rows in Other Table - For retrieving multiple matching records This works similarly to VLOOKUP in spreadsheets, allowing you to pivot data between tables based on your specified conditions.
Sources: Lookup Rows | Documentation | Clay University Lookup Multiple Rows in Other Table with Clay Conditional statements | Documentation | Clay University Conditional statements | Documentation | Clay University

Clay
APP
·
·
You can use the Lookup feature in Clay to pull data from one table to another based on variables. There are two options: 1. Lookup Single Row in Other Table - For retrieving one matching row (faster performance) • Select the table to search • Specify target column • Choose filter operator • Set row value 2. Lookup Multiple Rows in Other Table - For retrieving multiple matching records This works similarly to VLOOKUP in spreadsheets, allowing you to pivot data between tables based on your specified conditions.
Sources: Lookup Rows | Documentation | Clay University Lookup Multiple Rows in Other Table with Clay Conditional statements | Documentation | Clay University Conditional statements | Documentation | Clay University