Skip to main content
A
AndreaF
April 20, 2022
Solved

Transformation rules - Additional examples for the Range type expression

  • April 20, 2022
  • 1 reply
  • 0 views

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

 

Best answer by AndreaF

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.

1 reply

A
AndreaFAuthorAnswer
April 20, 2022

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.

S
SxD
July 24, 2024

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. 

Terms & ConditionsAccessibility statement