Skip to main content
Newcomer
September 26, 2024
Solved

ETL : Mapping entities/ transformation Rules

  • September 26, 2024
  • 1 reply
  • 0 views

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! 

Best answer by Henning

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_0-1727357601431.png

 

1 reply

HenningOneStream EmployeeAnswer
OneStream Employee
September 26, 2024

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_0-1727357601431.png

 

snouriAuthor
Newcomer
September 26, 2024

Hello, 

Thank you for you quick response. It works ! 

have a nice day