Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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