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
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Hi @Shruti1,
I share with you some useful documentation links to solve your issue:
Besides I give you a solution as a guidance, creating a calculated field:
<computedExpr expr="iBrandId == 0 ? 999999 : iEntityId"/>
Regards,
Celia
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_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
Hi @Shruti1,
I share with you some useful documentation links to solve your issue:
Besides I give you a solution as a guidance, creating a calculated field:
<computedExpr expr="iBrandId == 0 ? 999999 : iEntityId"/>
Regards,
Celia
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>