lygismav

Remove join table name from the field name- model builder

Discussion created by lygismav on Aug 17, 2011
Latest reply on Mar 26, 2012 by rosewl
Hello,

I an using model builder to join a table to a layer, then exporting that layer into a shapefile that permanently contains the data from the joined table.  At this time I am using "feature class to feature class to create my new shapefile."  The model seems to work, however I have a couple questions:

1)  By default most of the functions like to use field_join table as the name.  Feature class to feature class does allow us to rename fields.  However, it is time consuming to remove the table name from each of the field names.  Is there a quicker way?

2) When using feature class to feature class, is there a way to permanently control the field order.  Even if the layer file has been reordered and we use it as an input, feature class to feature class reverts back to the old field order.

Thanks

Outcomes