I have created and validated my transformation file, which takes two dimensions and concatenates them. For example Company and ProfitCenter, in the mapping section:
U_Entity=Company+ProfitCenter.
Where my company = 5110 and my profit center = SVS8110
The records are validated and in my output file I can see 5110SVS8110 and the associated transaction data.
However, in the *Conversion section of the Transformation file I reference the conversion file
U_Entity=U_EntityConv.XLS
Within the Conversion file, in the internal column I have 5110SVS8110, and in the external column I have UKSERVCO.
Both files are validated, but when I run the export transaction data package, the output file doesn't include UKSERVCO
In BPC 420 training it says *Conversion can be used to convert external keys from the flat file to internal keys. But can it convert internal keys to external keys in the flat file? If so, what do I need to do here?
Thanks.