ETL : Mapping entities/ transformation Rules

snouri
New Contributor

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! 

1 ACCEPTED SOLUTION

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:

Henning_0-1727357601431.png

 

View solution in original post

2 REPLIES 2

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:

Henning_0-1727357601431.png

 

snouri
New Contributor

Hello, 

Thank you for you quick response. It works ! 

have a nice day