AnsweredAssumed Answered

Is there an easier way to clone a data table and then edit the field names?

Question asked by BrendaSchick on Oct 26, 2014
Latest reply on Oct 26, 2014 by philmodjunk

Title

Is there an easier way to clone a data table and then edit the field names?

Post

I have a project where I have data tables of 500+ fields for Units 1-3, 4-6, 7-9 etc.  

 

 

 

I just finished cleaning up 1-3 from a research assistant.

There are a lot of changes I would need to make to clone 1-3 to 4-6.   Is there an easier way to do this other than editing 500 fields for 3 tables X 500.   Could I just export 1-3 to Xcel, then edit and then import into FMP?

Are there other ways to bulk search and replace?  

Brenda 

 

 

 

 

 

 

 

 

Outcomes