Skip to main content
Level 4
Oct 22, 2024 8:39 AM UTC
Solved

Stuck with how to do Join of schemas with condition in adobe campaign classic

 

Hello All,

 

Stuck with how to do Join of schemas with condition in adobe campaign classic

 

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

IF iBrandId = 0 then iBranchId=999999

else JOIN

customers.iBranchId =orders.iEntityId

 

 

Please suggest how can we o Join of schemas with condition in adobe campaign classic like this

please suggest and add your thoughts here

 

@parthasarathy 

@_manoj_kumar_ 

@davidkangni 

@akshayanand 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
ccg1706
ccg1706Accepted solution
Community Advisor and User Group Leader
Oct 24, 2024 2:14 PM UTC

Hi @shruti1,

 

In terms of doing the join conditions you can have a look at the following doc link.

 

Inside your xml schema you can use this solution as a guidance:

<join xpath-dst="@iEntityId" xpath-src="Iif(@iBrandId = 0, 999999, @iBranchId)"/>

 

Regards, 

Celia

 

 

 

1 reply

ccg1706
Community Advisor and User Group Leader
ccg1706Community Advisor and User Group LeaderAccepted solution
Community Advisor and User Group Leader
Oct 24, 2024 2:14 PM UTC

Hi @shruti1,

 

In terms of doing the join conditions you can have a look at the following doc link.

 

Inside your xml schema you can use this solution as a guidance:

<join xpath-dst="@iEntityId" xpath-src="Iif(@iBrandId = 0, 999999, @iBranchId)"/>

 

Regards, 

Celia

 

 

 

Translate