You can pull data from Table A to Table B based on column criteria using the "Lookup Rows" feature in Clay. This works similarly to VLOOKUP in spreadsheets.
There are two main options:
1. Lookup Single Row in Other Table: Use this when you need to find just one matching row. This is faster but limited to a single result. You'll need to specify:
• Table to Search (Table A)
• Target Column
• Filter Operator
• Row Value
2. Lookup Multiple Rows in Other Table: Use this when you need to find all rows that match your criteria.
Alternatively, you can use "Send table data" by:
1. Going to Actions → Send table data
2. Selecting your destination table
3. Choosing "Send row" and selecting which columns to transfer
This allows you to filter and transfer specific data between tables based on your criteria.
