topic Re: Masking dimentions/ variables in QlikView

Masking dimentions/ variables

ashishpalkar — Sun, 10 Jan 2016 18:54:02 GMT

Hi There

I have created around 200+ variables and the have names something like below.

%Region_1 which need to be changed as Region

I am looking for some script function which will help to change/mask the existing variable name.

Thanks in advance,

rwunderlich — Sun, 10 Jan 2016 19:08:47 GMT

If you mean Fieldnames, rather than Variable names; You can rename fields with the RENAME statement.

RENAME FIELD %Region_1 TO Region;

Or create a mapping load of all renames and use the statement:

RENAME FIELDS USING mapname;

-Rob

ecolomer — Sun, 10 Jan 2016 22:12:57 GMT

use MAPPING function