Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
ashishpalkar
Creator III
Creator III

Masking dimentions/ variables

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,          

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Master II
Master II