Forum Discussion

ZAH's avatar
ZAH
New Contributor
2 years ago

Complex Complex Expresion in Transformation Rules

Hello Everyone,    Is there a way to force the composite expression to run before the One To One Rules ?  i am trying to run a complex expression to override values coming from the Source Data....
Transformation
  • ChristianW's avatar
    ChristianW
    2 years ago

    In your case, I would suggest using composite rules instead of on-to-one mapping to differentiate mapping behaviours depending on the ud2 value. Also, composite rules have access to complex expressions and they are only slightly more complex than one-to-one.

ChristianW's avatar
ChristianW
Valued Contributor

 Just add the dimensional prefix, in case of an account mapping: A#1234567 becomes 60000:

 

MarcusH's avatar
MarcusH
Contributor III
2 years ago

I would keep the number of composites to a minimum because they are not as straightforward to administer. You only need to have 1 composite to set the UD2 to None for BS accounts - I would use the BRApi.Utilities.TransformText function in a Business Rule (set the source expression to UD2#*). Create a lookup table for the BS accounts and the Business Rule returns None if the account is BS, otherwise it returns nothing. Then put all the UD2 maps in the List type similar to the current One-to-One maps. I haven't tested it but it should work.