GTM Stack

How do I enrich data in one table with information from another?

I want to update existing rows in Table B with additional information from Table A based on a common field, without creating duplicate rows or just flagging matches.
February 2026

5 Answers

NULL

The original answer contains no actionable information—it only states that a particular approach doesn't work without explaining what the correct approach should be or providing any solution.

AI GeneratedFebruary 2026

NULL

The original answer does not contain actionable information. It only states a limitation ("will not enrich") without providing a solution to the user's question about how to enrich data from another table.

AI GeneratedFebruary 2026

NULL

The original answer contains no actionable information or solution. It only restates the problem without providing any guidance on how to enrich data from one table with information from another.

AI GeneratedFebruary 2026

Use the Lookup function to enrich data in one table with information from another table.

This approach works when you've already sent data to Table B and need to retrieve specific pieces of information that exist in Table A.

AI GeneratedFebruary 2026

Enriching Data Between Tables

To add information from one table to another, use the Lookup Single Row feature:

Steps

  1. Identify a common field between Table A and Table B (e.g., domain, ID, email)
  2. Use this common field as your Lookup identifier
  3. Perform the lookup on that field
  4. In the Lookup Row column, you'll see rows pulled from the other table
  5. 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
AI GeneratedFebruary 2026

Disagree or spot an error? Submit a correction here. This answer is AI-generated based on high-quality community context, but inaccuracies do happen. Your feedback helps us maintain the best information.

Add your take

Have experience with the tools discussed here? Share your honest opinion.