Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
SOLVED

Linking Schemas

Avatar

Level 4

Hi All,

 

I am having a hard time linking nms:recipients schema to nms:address schema. How can I link these two schemas together?

 

Thank You

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

There is no "technical link" between the 2 tables.

The only way to link them is to do a manual join based on the E-Mail address field

Example flow:

  • Query for profiles
  • Add reconciliation activity
    • Under relations add "address"
    • Then add a mapping from email on profile to address on address entry
1 Reply

Avatar

Correct answer by
Employee Advisor

There is no "technical link" between the 2 tables.

The only way to link them is to do a manual join based on the E-Mail address field

Example flow:

  • Query for profiles
  • Add reconciliation activity
    • Under relations add "address"
    • Then add a mapping from email on profile to address on address entry