I was using the Make Query Table tool in ArcGIS. Once the tool finishes running, the result (a table whose name I specify) is automatically added to the Table of Contents and I can view the data contained within. The source info shows that it's supposed to be stored inside of the geodatabase from which one of the tool's inputs was selected. However, I cannot find the table in the geodatabase. How can I locate this table?
-
Did you do a Refresh in ArcCatalog?– Dan CAug 20, 2015 at 19:20
Add a comment
|
1 Answer
First you should verify the source of the table - this will make sure it's not somewhere that you don't expect or intend.
Do this by opening the properties window for the table and going to the 'Source' tab. Make sure that the table ended up in the place you're looking.
If you can verify the source but still can't see it in the database - try refreshing your display of the database contents - either press F5 (with the database selected) or right-clicking and choosing "Refresh".
EDIT -
After looking at the ESRI documentation for the tool it seems that the layer is indeed temporary. A new table is not created.
-
Thank you. As stated in my post, I did check the source and it pointed to the geodatabase. I also refreshed it and restarted several times and still no table. However, I am beginning to think that the tool (Make Query Table) may actually not create a table (though it looks like one), but rather store query results accessing data from another input table. Maybe I have to export the final results to another table? Aug 20, 2015 at 18:46
-
"The layer that is created by the tool is temporary and will not persist after the session ends unless the document is saved." From the ESRI help on the tool.– KevinAug 20, 2015 at 18:48
-
That is the issue. I just exported the results to another table and the problem is solved. Thanks. Aug 20, 2015 at 18:49
-