1to many cardinality in Adobe campaign classic

Question

hiaLL , please helpi have 2tabes --transaction table(ELC:TRANSACTION ) and receipeiNT(ELC:RECEIPIENT) table and i want to create 1to many link between them in schemaIn 1 to Many cardinality,the code should be written in Target (Many-N) schema.In the below example, I have written the code in ELC:TRANSACTION schema. SO THE code should be written like that according to me butwhat i found is another adobe doc where its defined in diff way:LINK https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/editing-schemas/about-schema-edition.html?lang=en#enumerations please help me which one is correct method and what is the diff between the two why so why it is using revlink.....we shoulsd use revlabel only what and when we use revlink in schema @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

LakshmiPravallika · Accepted Answer

Hi @shrutii ,

You can refer to the below solved post for revLink usage

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/usage-of-revlink-attribute-in-schema-s/m-p/284446#:~:text=We%20use%20revLink%20attribute%20in%20a%20link%20when,the%20source%20table%20and%20name%20of%20the%20link.

Also, we can create temporary 1 to many Link using Enrichment activity(useful in calculating aggregates or temporary values useful for that particular Workflow) but if you want you can do it from the Schema level so that its not required to create every time in the Workflow.

For this use case:

If we mention type="link" without explicitly mentioning the Joining keys, then Adobe Campaign will automatically consider the primary keys (they should have the same Data type ) in both the Schemas as the Joining keys. You can check it it Preview Tab of the Schema after adding the Link and Update DB Structure.

Regards,

Pravallika.

AnanthanJa · Answer

Hi @shrutii,

Links which we create in Adobe Campaign are basically join conditions which are enabled.

As per your case, each transaction has a mapped recipient record(1:1) and each recipient can have more than one transaction record.

When the link is created from transaction through the following code

<element label="Recipient" name="recipient" revLabel="Recipient Trnsaction" target="nms:recipient"

type="link">

</element>

The link is created using the default revlink name of the source schema name which is transaction and also the fields id in recipient and irecipientid in transaction needs to be created upfront.

However, when the link is created from transaction through the following code

The field irecipientid in transaction is automatically created and the rev link name as what you provide is used.

Additionally, the relink is the name that will be used in queries when the fields in the transaction are referenced from the recipient.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded