Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
heerarega
Contributor III
Contributor III

Rename field names

Hello,

I am looking for some help in renaming the filed names.

I have a scenario where my filed names are like Customer Name, Customer City, Customer Location etc;. I have to change them to Member Name, Member Location, Member City,etc., i.e the fields like Customer * should be changed to Member *. I used mapping load and the function 'rename fields', but again since this approach needs to maintain a list of old and new filed names, I am trying avoid this instead trying for a solution using wildcard match like field names starting with 'Customer *' should be changed to 'Member *'.

Any help would be highly appreciated.

Thanks

Heera

2 Replies
jonasheisterkam
Partner
Partner

You can build a loop with nooftables(), Tablename(), nooffields(), fieldname() to generate the mapping table during the loop after your normal script where you can search in the fieldname vor your wildcards. In the gui you can build the fieldnames with variables.

heerarega
Contributor III
Contributor III
Author

Hi Jonas,

Thank you for the reply. I am trying to achieve the above task in my UI. What I am doing here is  I am calling all my QVDs in a loop, once the tables are created in UI ,then I am trying to rename the fields.

Can you please try to post a sample script with the above suggestions you made.

Thanks

Heera