Global Rename usimg Exported Structure

[hdonald]

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,

HD

[stephencredmond]

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