How to transform (not map) the Source-Entity column based on another dimension
I'm trying to find a way to transform the Source-Entity based on another dimension, so that the result can still be mapped after.
Let's say I'm loading the following extract into Data Management:
(Source-)Entity, (Source-)CostCenter, Value
Texas, 10001, 100,00
Texas, 20001, 100,00
I'm trying to find a way to transform the Source-Entity based on the Cost Center column. However, I need this to happen before the mapping, so similar to using a logic group that transforms/creates values that can still be mapped after.
The result should be:
Texas1, 10001, 100,00
Texas2, 20001, 100,00
Version (include the version you are using, if applicable):