topic Rename data when loading in QlikView

Rename data when loading

Wed, 26 May 2010 10:24:42 GMT

Hi all!

Is it possible to rename values coming from load statement ? for exemple:

Load

Countries,

cities

from location where match(Countries, 'US', FR, 'EN');

I want to rename when I will create a listbox with the field 'countries', 'US' by 'Etats-Unis', 'FR' by 'France' ...

thanks,
Aziz

Rename data when loading

Anonymous — Wed, 26 May 2010 10:29:42 GMT

Hi Aziz,

I would suggest creating a "Mapping table" (see F1-help or reference manual for syntax) and then use the ApplyMap() function in this load statement to map the Countries values against the values from the mapping table.

Rename data when loading

Wed, 26 May 2010 10:40:38 GMT

Hi Aziz,

I hope you have to use a mapping load here for a solution. Just try out my code and see whether you are getting your desired output.

Map1:

Mapping Load * inline

[

x,y

US, Etats-Unis

FR, France

EN,England

];

Map Countries using Map1;

Data:

Load

Countries,

cities

from location;

Thanks Joseph............

Rename data when loading

Wed, 26 May 2010 10:59:05 GMT

Thanx to all!

Joseph I get the result I disired with your code.

Regards