I've googled myself to death on the interwebs and can't find any solution.
I have a table of data that I import with field names for example
I design the model using these original field names, however they don't mean anything much to the end user. So what I need is to assign user friendly labels that can be referenced in the headings and charts instead of these database fields.
My current approach is to load an inline table where the original field name is specified as well as an alternative user friendly field like ...
Load * inline [
Field_abc, Product Field_def, Country
Now I can come right with a 'RENAME FIELDS USING FIELDMAP' process ....
Buuuuuut .... it REPLACES the original field name with the alternative field name.
Normally I won't mind, but in this case (and for future dynamic design), I need to RETAIN the original field name as well as the new alternative field name.
The obvious answer is to do something like
Field_abc AS Product,
Field_def AS Country,
Field_ghi AS Region,
Field_jkl AS Segment,
But this balloons the data since I'm not allowed to drop the original field. I'm pretty sure I need to use an 'applymap' function, but I'm not getting it right.
It isn't possible to have to two field-names for one field. If you really want to keep the origin field-names within the enduser-reports you will need to translate them then with an expression - best practice is to use a 3-tier data architecture with generator --> datamodel --> report and change the fieldnames on the scriptend from datamodel or from report the origin field-names into user-friendly ones per rename-statement.
The above mentioned expression alternatively requirred an additionally table similar like a mapping table and could look like: