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 underscores instead (e.g., "ENT_BER").I'm looking for an efficient way to automatically transform these Entity codes during the import process without having to create individual mappings for each entity.

Where in the OneStream configuration should I add this transformation rule? In the Data Source settings, Transformation Rules, or somewhere else?

Any guidance or examples would be greatly appreciated. Thank you in advance for your help! 

  • 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

      Hello, 

      Thank you for you quick response. It works ! 

      have a nice day