Rename data when loading

[#1]

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

[Anonymous]

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.

[#3]

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............

[#4]

Thanx to all!

Joseph I get the result I disired with your code.

Regards