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?
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.