04-20-2022 11:24 AM - last edited on 05-03-2023 12:02 PM by JackLacava
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
Solved! Go to Solution.
04-20-2022 01:24 PM
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.
04-20-2022 01:24 PM
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.
07-24-2024 12:32 AM
Thank you for this! I'm not sure why it has to be loaded again, I thought that was only for Parser rules to kick in.