Automatic Field Name Updates
aveenm293
Forums
Hi Brian
I am trying to create a custom script that will automatically update field names without manually updating each of them using Field Manipulation. Essentially I would import two separate files. One would contain the "Raw Field Name" and "Updated Field Name". The other file would be the dataset on which the field names need to be updated. I have attached an example dataset. For example:
The field AN8 represents the Employee Number. In the Data Set Tab we would need to rename the column "AN8" to "Employee Number".
Any ideas on how to start this script for IDEA 9?
Thank you
Regards
Aveen
Hi Aveen,
Hi Aveen,
What I would do is read through the file with the raw and updated names. I would use the rename field function I have here (http://ideascripting.com/snippet/renamefields-function) and then for each row in the database I would send the name of the database to be updated with the old name and the new name that you have read from the name update database.
Let me know if you need help writing the script.
Brian