Skip to main content
Newcomer
Jul 19, 2024 3:18 AM UTC
Solved

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?

 

TT8Answer
Newcomer
Jul 22, 2024 3:48 PM UTC

Below mapping works:

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

3 replies

TT8Author
Newcomer
Jul 19, 2024 3:42 AM UTC

It is resolved. Please ignore above thread.

Jul 19, 2024 3:36 PM UTC

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

Thank you.

TT8AuthorAnswer
Newcomer
Jul 22, 2024 3:48 PM UTC

Below mapping works:

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