Forum Discussion

vijay's avatar
vijay
New Contributor III
2 years ago

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:

Validaiton error:

 

 

3 Replies

  • AndreaF's avatar
    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's avatar
      vijay
      New Contributor III

      Thanks , Any sample or link for the above.

  • AndreaF's avatar
    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:

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