Forum Discussion

snouri's avatar
snouri
New Contributor II
3 months ago

ETL : Mapping entities/ transformation Rules

Hello OneStream community,I'm working on a data import process where our source file contains Entity codes with hyphens (e.g., "ENT-BER"), but in our OneStream application, these codes use underscore...
Import
Transformation
  • Henning's avatar
    Henning
    3 months ago

    Hi, it's been a while since I used those, but the substitution settings on the data source should provide you with what you need:

     

Henning's avatar
Henning
Valued Contributor II

Hi, it's been a while since I used those, but the substitution settings on the data source should provide you with what you need:

 

snouri's avatar
snouri
New Contributor II
3 months ago

Hello, 

Thank you for you quick response. It works ! 

have a nice day