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
BedrockMission!

Learn More

View all

Sign in to view all badges

Linking Schemas based on 2 Attributes

Avatar

Avatar
Validate 1
Level 1
joel51583885
Level 1

Likes

3 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 1
joel51583885
Level 1

Likes

3 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
joel51583885
Level 1

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
Affirm 25
Level 4
Deb007
Level 4

Likes

50 likes

Total Posts

86 posts

Correct Reply

25 solutions
Top badges earned
Affirm 25
Boost 25
Applaud 5
Give Back 5
Validate 1
View profile

Avatar
Affirm 25
Level 4
Deb007
Level 4

Likes

50 likes

Total Posts

86 posts

Correct Reply

25 solutions
Top badges earned
Affirm 25
Boost 25
Applaud 5
Give Back 5
Validate 1
View profile
Deb007
Level 4

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)