How to add calculated filed in schema to add join in schemas with conditions | Community
Skip to main content
S
Shruti1
Level 4
October 23, 2024
Solved

How to add calculated filed in schema to add join in schemas with conditions

  • October 23, 2024
  • 2 replies
  • 998 views

Hello All,

 

I am stuck in a requirement where I have to do Join of schemas with condition in adobe campaign classic like this:

Do I need to use calculated filed to achieve this

IF iBrandId = 0 then iBranchId=999999

else JOIN

customers.iBranchId =orders.iEntityId

 

Please suggest how can we do Join of schemas with condition or Calculated fields in adobe campaign classic like this

please provide some examples

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 ccg1706

Hi @shruti1,

 

I share with you some useful documentation links to solve your issue:

Schemas 

Schema reference 

 

Besides I give you a solution as a guidance, creating a calculated field:

 

<computedExpr expr="iBrandId == 0 ? 999999 : iEntityId"/>

 

Regards, 

Celia

 

2 replies

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity Advisor
Community Advisor
October 23, 2024

Hello @shruti1 

 

You will have to break this in two parts.

 

Part1: Decide the Branch ID. Use the enrichment to create a calculated field and use If condition to set the branch ID to 0 or 999999

Iif(iBrandId ='0',9999999 ,iBrandId )

 

Now you can use the enrichment to set the join base branchId without any additional conditions

Manoj     Find me on LinkedIn
    S
    Shruti1Author
    Level 4
    October 24, 2024

    @_manoj_kumar_  thanks for your reply but I got the requirement to add this at schema level-in EDIT tab of schema

     

    Condition:

    IF iBrandId = 0 then iBranchId=999999

    else JOIN customers.iBranchId =orders.iEntityId

     

    could you please suggests something

      ccg1706
      Community Advisor
      ccg1706Community AdvisorAccepted solution
      Community Advisor
      October 25, 2024

      Hi @shruti1,

       

      I share with you some useful documentation links to solve your issue:

      Schemas 

      Schema reference 

       

      Besides I give you a solution as a guidance, creating a calculated field:

       

      <computedExpr expr="iBrandId == 0 ? 999999 : iEntityId"/>

       

      Regards, 

      Celia

       

        somasundaram_h
        Community Advisor
        somasundaram_hCommunity Advisor
        Community Advisor
        November 6, 2024

        Hi,

         Have you tried this attribute dstFilterExpr? I won’t suggest to have static values in the join links. But you can try to use you don’t find any other options. You need to have 2 links.

         

         <element name="orders" type="link" label="MyLink" target="cus:orders">
        <join xpath-dst="@entityid" xpath-src="’999999’" dstFilterExpr="@branchid = '0'"/>
        </element>

         

        <element name="orders" type="link" label="MyLink2" target="cus:orders">
        <join xpath-dst="@entityid" xpath-src="@branchid" dstFilterExpr="@branchid != '0'"/>
        </element>

         

          Terms & ConditionsAccessibility statement

          Loading footer...