Rename fields by mapping table in Qlik Sense

[beck_bakytbek]

Hi Folks,

does anybody have an example or qfv-file, how to rename fields in Qlik Sense by using of mapping table

Thanks a lot in advance

Beck

[Anonymous]

Hi Beck,

You need to create a another Load statement to rename this using aliases.

complete your mapping and take resident of the fields you want and rename them.

Regards,

Rajan Kasbe

[OmarBenSalem]

Hi Beck, can you elaborate with a simple example?

Maybe 2 dimensions, 4 or 5 lines of values and what you want to change and how?

Thanks

[beck_bakytbek]

Hi Omar,

i find this issue:http://www.learnallbi.com/renaming-fields-in-qlikview-using-mapping-load/

i wanted to recreate this example, but i didnt achieve the correct results

Thanks a lot

Beck

[beck_bakytbek]

HI Rajan,

first of all thanks a lot for your responce, do you have any example to your above explanation.

Thanks a lot

Beck

[OmarBenSalem · Accepted solution]

Try this :

map:

mapping load * inline [

name, NewName

omar, OBS

];

table:

load id, ApplyMap('map',oldName,oldName) as NewName Inline [

id, oldName

1, omar

2, beck

]

;

result:

[beck_bakytbek]

Omar, thanks a lot,

on the base of above link to issue of renaming of fields: i didn't know, that the Function: ApplyMap () must be used. I thought, the renaming of fields is possible only with Mapping load without ApplyMap().

Or am i missing something?

Beck

[OmarBenSalem]

Mapping load table will contain the newName field .

You HAVE to use ApplyMap function to use the mapping load table.

[beck_bakytbek]

Thanks a lot Omar

[m_s]

Hello Beck,

I tested the link you posted and it is working as expected in Qlik Sense (September 2017). I think you had a different issue if your fields were not renamed properly.

I executed the following script and it resulted in a table with fields "New Name A" and "New Name B":

LOAD * Inline

[a,b

abc,123

defg,456];

m_Fields:

MAPPING LOAD * Inline

[OldName,NewName

a,New Field A

b,New Field B

];

RENAME FIELDS using m_Fields;

Regards,

Mathias