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

[Shruti1]

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 

[ccg1706 · Accepted solution]

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