Transformation rules - Additional examples for the Range type expression

AndreaF
Contributor III

Hi,

the OneStream XF design and reference guide mentions that: "If an administrator wants the range of source Accounts from 11202 to 11209 to map to Account 12000, then he/she would enter 11202~11209 under Rule Expression with ~ as the separator."

 

What if the Accounts in the range have leading or trailing characters? Let say all my accounts start with A_

I have tried to use the the following expression: A_11202~A_11209, but it does not seem to work.

Any suggestion? Thank you

 

1 ACCEPTED SOLUTION

AndreaF
Contributor III

Using the A_11202~A_11209 expression actually works. The issue was that I using the "Retransform" button in the import step. That's apparently not enough, data have to be reloaded using the "Load and transform" button for the transformation to be applied correctly.

View solution in original post

1 REPLY 1

AndreaF
Contributor III

Using the A_11202~A_11209 expression actually works. The issue was that I using the "Retransform" button in the import step. That's apparently not enough, data have to be reloaded using the "Load and transform" button for the transformation to be applied correctly.