physical model - best way to save column name
I am using PD 16.5 SP03 PL03. I am reviewing a table in a physical model that has 100 columns. The column names given are all cryptic and do not meet standards. I am in the process of Changing the column names to more meaningful names. But we have a ETL mapping already defined for this table using the existing non-standard columns. So it is important for me to remember what I have changed so I can apply the same changes to the etl mapping document.
My question is, Is there any way I can create a hidden column in PD for the table (in fact to all the tables in the model) and run a script to copy the current Code to this hidden column. This way once i change the name, I can produce a listing (with the help of hidden column), old name and new name.
Anthony Hill replied
You can create an extended attribute on the Column metaclass to store the value of the original column. You can then write a VBscript to populate the extended attribute. If you do not want write a VBscipt, you can also import the information from Excel.
For example, I did the following:
Open Table Properties and select the Column tab
Display the Parent column
Export the list to Excel
In Excel, I rename the Name column to OldName
I modified my spreadsheet to something like the following:
Attach the Excel Import extension file
Import the Excel file as Table.Column
Click through the Import wizard, for the OldName column, click the New tool to create an extended attribute
End result is something like the following:
You can then decide to hide or display the OldName column.