ETL : Mapping entities/ transformation Rules

[snouri]

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! 

[Henning · Accepted solution]

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]

Hello, 

Thank you for you quick response. It works ! 

have a nice day