Linking Schemas based on 2 Attributes

Avatar

Avatar

joel51583885

Avatar

joel51583885

joel51583885

12-11-2018

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Deb121

Avatar

Deb121

Deb121

14-11-2018

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

Answers (0)