Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
4 years ago

Sign Flip for Account in Transformation Rule (Complex Expression)

Originally posted by Krishna Srinivasan

Hi - I have a requiremnt to flip a sign for a particular account in the transformation rule complex expression ? is there way to do it ?

 

Thanks

Krishna

Transformation
  • OSAdmin's avatar
    OSAdmin
    4 years ago

    If it is a particular account and only one account make it simply a one-to-one.  No need to get crazy with complex expressions.    Use the simplest method first.   

     

    Even if its in a range of accounts, such as 100-200, if you put 150 in the one-to-one it will be the dominant mapping. 

     

    If it requires other information, there are multiple ways to achieve this.  Does it need information from another dimension such as source product?   You can use a composite rule.   

  • OSAdmin's avatar
    OSAdmin
    Valued Contributor
    4 years ago

    If it is a particular account and only one account make it simply a one-to-one.  No need to get crazy with complex expressions.    Use the simplest method first.   

     

    Even if its in a range of accounts, such as 100-200, if you put 150 in the one-to-one it will be the dominant mapping. 

     

    If it requires other information, there are multiple ways to achieve this.  Does it need information from another dimension such as source product?   You can use a composite rule.