Skip to main content
V
vijay
September 19, 2023

Transformation rules Subtract two accounts

  • September 19, 2023
  • 2 replies
  • 0 views

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

 

 

2 replies

A
AndreaF
September 19, 2023

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.

V
vijayAuthor
September 19, 2023

Thanks , Any sample or link for the above.

A
AndreaF
September 20, 2023

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