Forum Discussion

ST1's avatar
ST1
New Contributor III
6 months ago

Composite Transformation Rule with Range and List

I need to create a composite mapping :

For UD2, If Account is in range of 6099* and 6999* and UD2 is  [123 or 124], then UD2 is 100.

In UD2 composite,

If I put rule expression in composite like:   A#6099*~6999*     Target 100,  it works.

But, I put expression in composite like:   A#6099*~6999* : UD2#123;124   Target 100. It does not work.

It is ok, if I can even make  A#6099*~6999* : UD2#123 work. I can split above in 2 lines for list. But, I need condition for range and another dimension member.

Any suggestions?

 

  • Below mapping works:

    A#[6099*~6999*]: U2#[123;124;12000] works

  • Rich_House's avatar
    Rich_House
    New Contributor III

    For those that would like know, would you be kind enough how you resolved it

    Thank you.

  • ST1's avatar
    ST1
    New Contributor III

    Below mapping works:

    A#[6099*~6999*]: U2#[123;124;12000] works

  • ST1's avatar
    ST1
    New Contributor III

    It is resolved. Please ignore above thread.