Forum Discussion

Samwise's avatar
Samwise
Icon for OneStream Employee rankOneStream Employee
6 months ago

Bypass Characters in Transformation Rules

I am curious if there is a way to bypass characters in a transformation rule without using a complex expression. For example, 000485 (Source) -> 458 (Target) 394904 (Source) -> 904 (Target)  
Metadata
Samwise's avatar
Samwise
Icon for OneStream Employee rankOneStream Employee
6 months ago

Unfortunately, you will need to have ??? on both sides. It would have to look something like ???485 (source) -> ???485 (Target), else it will return on error.

MG's avatar
MG
Icon for OneStream Employee rankOneStream Employee
6 months ago

As MarcusH​ says, a mask mapping with ???485 as the expression and 485 as your target should work. I have a similar mapping mapping ???80 to Target acct 10000