Skip to main content
July 19, 2024
Solved

Composite Transformation Rule with Range and List

  • July 19, 2024
  • 3 replies
  • 0 views

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?

 

Best answer by TT1

Below mapping works:

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

3 replies

TT1Author
July 19, 2024

It is resolved. Please ignore above thread.

July 19, 2024

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

Thank you.

TT1AuthorAnswer
July 22, 2024

Below mapping works:

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