Expand my Community achievements bar.

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

2 Replies

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

Avatar

Level 1

<element externalJoin="true" label="Active Subscriber Wx" name="activeSubscriberWxTest"
target="rqa:activeSubscriberWxTest" type="link">
<join xpath-dst="@ECID" xpath-src="@ECID"/>
</element>

Both table has ECID column and i was able to save the schema. But in the structure tab i dont see the ACTIVE_SUBSCRIBER_WX table linked to CUSTOMER table. I updated the schemas as well. 

Note: These are two different schema created using FDA. This cannot be joined?