Skip to main content
vijay
Newcomer
Sep 19, 2023 7:19 AM UTC

Transformation rules Subtract two accounts

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

AndreaF
Expert
Sep 19, 2023 8:59 AM UTC

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.

vijayAuthor
Newcomer
Sep 19, 2023 12:46 PM UTC

Thanks , Any sample or link for the above.

AndreaF
Expert
Sep 20, 2023 8:35 AM UTC

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

Terms & ConditionsAccessibility statement