Skip to main content
Newcomer
Sep 26, 2024 1:23 PM UTC
Solved

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! 

HenningAnswer
Employee - Advisor
Sep 26, 2024 1:33 PM UTC

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

 

2 replies

HenningEmployee - AdvisorAnswer
Employee - Advisor
Sep 26, 2024 1:33 PM UTC

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
Sep 26, 2024 2:58 PM UTC

Hello, 

Thank you for you quick response. It works ! 

have a nice day