Join will not export with features

Question

I have successfully completed an attribute Join. And when I Export (in order to have a new Layer with these joined fields) it does so. However, wen I add this new Feature Class to the map there are NO records, no map.

...What might be causing this behvior?

Thanks!

JoeBorgione · Answer

Glad you got it to work for you: I think Excel is a great spreadsheet app.  I use it for all my billing and tax records.

However, if get 'data' sent to me in the form of an Excel spreadsheet, the first thing I do with it is import it as a table to a geodatabase.

CraigEissler · Answer

Thanks. Well, I tried the Join using ArcToolbox. This approach adds the join permanently to the Input-Target Layer. I thought that might help me avoid having to Export the join as a new Layer. ...But yes, I want the join to be permanent so that I can perform field functions that you cannot when it's only in temporary condition.

Interestingly, this ArcToolbox approach gave me an Error indicating my Join Table did not have an OID Field. I knew that since this was an Excel Table, but didn't think I needed one to do a Join. But anyway, I followed the suggestion of using the Data Management > Copy Rows tool to create an OID for that Table. That worked. Then, I tried the Join (from ArcToolbox) again, and this time it worked -- I have a permanently join Layer!

HaskettGeorge · Answer

Can you describe your steps with a little more detail?

Attribute table joins are best viewed as a temporary tool.  A feature lyr is also more or less a temp view of the data in question.

Use the Feature Class to Feature Class tool to create a new feature class with all of the desired fields, then you can manipulate it how you want.