I am trying to iterate through an excel with over 200 sheets and join each to a ZIP code layer. I then need to symbolize each of those the three different ways and save that to a layer file. In order to do that, I need the model to keep the original field names so the symbology can be done for all. Here is what my model looks like
I have tried multiple routes to keep the field names. Utilizing the field info variable from Make Feature Layer, I can have the fields from the layer I am joining to (ZIP 2014) keep their original names, but the fields from the table still use the "Sheet__fieldname" convention and the fields from the table are what I have to base the symbolization on. I have unchecked maintain fully qualified field names for the Model properties as well as for the individual tools, and that doesn't work.
My only workaround has been to export everything in the model as is, then create another model and use feature class to feature class to change the field names. I truly believe there has to be some way to get all this done in one swoop.
I am using ArcMap 10.2.2