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: