Hi - I am joining a feature class with a table in model builder and then trying to export the result to a new feature class. When I hard-code the layer and table names it works fine. I get complete geometry as well as all of the fields in the attribute table as expected. When I try to use a variable as part of the layer and table names, however, the resulting feature class has the correct geometry, but contains only Shape, Shape_Length, and Shape_Area fields. Any idea what could be going wrong?
My variable is named AgencyName and is also set as a parameter. I refer to the variable value in my join tool like this: %AgencyName%. Both the input table and the join table are in a fileGDB and are referred to using the complete path (P:\projects\xyz\OrangeParse.gdb\MSA_%AgencyName%). I've confirmed the value of my variable name is correct.
Any ideas what could be happening here? Attached is a screen shot of the model
Thanks Pete