


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?
Solved! Go to Solution.
Views
Replies
Sign in to like this content
Total Likes
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
Views
Replies
Sign in to like this content
Total Likes
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
Views
Replies
Sign in to like this content
Total Likes