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 based on 2 Attributes

Avatar

Level 2

Hi, I currently have my custom table "Contact Us Submissions" linked with my Recipients table using just the "email" field as seen here:

<element externalJoin="true" label="Contact Us Submissions" name="contactUsSubmissions"

     target="cus:contactUsSubmissions" type="link" unbound="true">

     <join xpath-dst="@email" xpath-src="@email"/>

</element>

I want make sure they are linked together by "email" AND another custom attribute, "brandOwner"

How would I make sure my table is linked together based on the combination of "email" and "brandOwner" attributes as reconciliation keys?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi joel51583885

You can do so by adding join to your link like the following

<element externalJoin="true" label="Contact Us Submissions" name="contactUsSubmissions"

     target="cus:contactUsSubmissions" type="link" unbound="true">

     <join xpath-dst="@email" xpath-src="@email"/>

     <join xpath-dst="@brandOwner" xpath-src="@brandOwner"/>

</element>

But you need to make sure that corresponding columns are present in respective schemas.

Regards,

Deb

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi joel51583885

You can do so by adding join to your link like the following

<element externalJoin="true" label="Contact Us Submissions" name="contactUsSubmissions"

     target="cus:contactUsSubmissions" type="link" unbound="true">

     <join xpath-dst="@email" xpath-src="@email"/>

     <join xpath-dst="@brandOwner" xpath-src="@brandOwner"/>

</element>

But you need to make sure that corresponding columns are present in respective schemas.

Regards,

Deb