Transformation rules - Additional examples for the Range type expression
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
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.
