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

Question

Hello All,

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

ccg1706 · Accepted Answer

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

Sign up