topic Re: Join will not export with features in Data Management Questions

Join will not export with features

CraigEissler — Tue, 25 Nov 2014 15:48:24 GMT

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!

Re: Join will not export with features

RuiSantos_EsriPT — Tue, 25 Nov 2014 15:57:43 GMT

After the Join did you export your data to a Geographical format? Which one?

Re: Join will not export with features

HaskettGeorge — Tue, 25 Nov 2014 16:08:19 GMT

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.

Re: Join will not export with features

CraigEissler — Tue, 25 Nov 2014 16:45:03 GMT

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!

Re: Join will not export with features

JoeBorgione — Tue, 25 Nov 2014 17:13:25 GMT

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.