Forum Discussion

AndreaF's avatar
AndreaF
Contributor III
3 years ago

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~112...
Methodology
  • AndreaF's avatar
    AndreaF
    3 years ago

    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.

AndreaF's avatar
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.

SxD's avatar
SxD
New Contributor III
5 months ago

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.