Global Rename usimg Exported Structure

hdonald — Tue, 12 Apr 2011 15:25:40 GMT

Hi All,

Is anyone using the "Rename Fields Using mapping Table" functionality to clean up their whole qvw data model - rather than just a few fields ? Is this feasible ?

After developing a set of in-memory tables with a rather untidy set of field names - spoiling the look of the 'Current Selections' window and upsetting users - I'd considered the following;

Dump out to an Excel table the entire list of Tables/Fields in the qvw using Settings / Document Properties / Tables / Export Structure.
Add columns to the Excel document with 'user friendly' field name and 'Help text' where needed - maybe 1 in 10 fields.
Load table in as a Data Dictionary table and create a Mapping Table of Old Name & New Name.
At the end of the script use 'Rename Fields Using Mapping Table' to globally rename all fields with new user friendly names.
Add the Data Dictionary table to a 'Help' tab.

As long as care is taken to use a naming convention that avoids creating new associations this would seem to work - anyone else doing this ? Any pitfalls ?,

Regards,

Global Rename usimg Exported Structure

stephencredmond — Tue, 12 Apr 2011 15:55:34 GMT

Hi,

As you say, use care to avoid new associations - but that should happen if you rename everything anyway - and you should be good to go.

In QV10, you can also load your descriptions as metadata.

Regards,

Stephen

topic Global Rename usimg Exported Structure in QlikView

Global Rename usimg Exported Structure

Global Rename usimg Exported Structure