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 ?,
