1to 1 cardinaltiy in Adobe campain classic | Community
Skip to main content
S
Shrutii
Level 4
February 28, 2024
Solved

1to 1 cardinaltiy in Adobe campain classic

  • February 28, 2024
  • 2 replies
  • 778 views

hi all, please help me 

 

@isahore 

 

 

@AndreaBriceno

@ParthaSarathy

@ParthaSarathy 

@ParthaS 

@AkshayAnand 

@Craig_Thonis 

@Manoj_Kumar_ 

@Amine_Abedour 

@Marcel_Szimonisz

@DavidKangni 

@Amit_Kumar 

@ShashankNigam02

@Ganesh5067

@Jonathon_wodnicki

 

@ParthaSarathy

@ParthaSarathy 

@ParthaS 

@AkshayAnand 

@Craig_Thonis 

@Manoj_Kumar_ 

@Amine_Abedour 

@Marcel_Szimonisz

@DavidKangni 

@Amit_Kumar 

@ShashankNigam02

@Ganesh5067

@Jonathon_wodnicki

i need to crate a 1to 1 link between customer schema and country schema

please help me with syntax,i checked the documentaion but its somewhat confusiing

 we can write the link definition in any of the schema in 1to1 cardinality

 is this correct ,i have written this in country schema

 

<element revCardinality="single" label="customer " name="customer " revLabel="linkcountry" target=elc:customer" type="link">                                                                                                                      <join xpath-dst="@1716897 " xpath-src="@countryid "/></element>

 

what if i have to define this 1to 1 link in recipient schema but not in country scheam,please help me on code please

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ParthaSarathy

Hi @shrutii ,

Logically the relationship between a country table and customer table is 1 to Many.

But in general if you want to create 1 to 1 link between 2 schema, then you can write the join script in any of the schema. Example, if you write the join script in Table A, mention target="abc:table_B" in element tag. And if you decide to write the join script in Table B, mention target="abc:table_A" in element tag.

2 replies

AkshayAnand
Community Advisor
AkshayAnandCommunity Advisor
Community Advisor
February 28, 2024

Hi @shrutii 

 

rev Cardinality is the reverse cardinality which you will b defining, if you have written the code in country schema then single cardinality will be create in the reverse way, ie, from recipient to country schema and vice versa. Reverse link [from recipient to country] will have single Recipient will have only one country (1-1) but forward [from country to recipient] will be one Country will have many recipients (1-N).

For more details you can visit the documentation.

 

Regards

Akshay

    ParthaSarathy
    Community Advisor
    ParthaSarathyCommunity AdvisorAccepted solution
    Community Advisor
    February 28, 2024

    Hi @shrutii ,

    Logically the relationship between a country table and customer table is 1 to Many.

    But in general if you want to create 1 to 1 link between 2 schema, then you can write the join script in any of the schema. Example, if you write the join script in Table A, mention target="abc:table_B" in element tag. And if you decide to write the join script in Table B, mention target="abc:table_A" in element tag.

    ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
      Terms & ConditionsAccessibility statement

      Loading footer...