Transformation rules Subtract two accounts

vijay
New Contributor III

hi,

Two account A and B needs to be subtracted in the source applicaiton and assigned to the third account on destination application  in the transformation rule for App2App copy process . Below is my Composite but its throwing error for one-one transformaton mapping.  

TR Composite Rule:

vijay_2-1695107885474.png

Validaiton error:

vijay_1-1695107835190.png

 

 

3 REPLIES 3

AndreaF
Contributor III

The Rule expression field of a Composite map rule is meant to define the conditional mapping, eg. A#[199?-???*]:E[Texas], it is where you specify the source field. You need to use the logical operator field to extend the normal mapping rules with VB script functionality. However, in your case I would probably use derivative rules.

vijay
New Contributor III

Thanks , Any sample or link for the above.

AndreaF
Contributor III

I had a second thought about it, and the easiest way is actually just using 2 one-to-one mapping rules, with signed flipped on the second to indicate the value must be subtracted instead of added. Like this:

AndreaF_0-1695198952151.png

Please mark the post as answered if this solves your issue. Thank you