Enriching Data Between Tables
To add information from one table to another, use the Lookup Single Row feature:
Steps
- Identify a common field between Table A and Table B (e.g., domain, ID, email)
- Use this common field as your Lookup identifier
- Perform the lookup on that field
- In the Lookup Row column, you'll see rows pulled from the other table
- Add those columns to your original table
Key Points
- Lookup Single Row isn't limited to flagging or filtering duplicates—it's useful for data enrichment
- The common field acts as the bridge between your two tables, matching records so additional information can be transferred
GTM StackCommunity Insight