Linking Schemas based on 2 Attributes

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)

Debabrata_T

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)