topic Re: Simple Attribute Join Error: "Resulting Table Has No Rows" in ArcGIS Pro Questions

Simple Attribute Join Error: "Resulting Table Has No Rows"

GraceVan_Horn — Thu, 16 Nov 2017 22:36:53 GMT

I'm attempting to do what I think is a very simple join, but for some reason I'm getting the error that "the join was successful however the resulting table has no rows." I'm trying to join based on a unique attribute, titled "FID" in both the original layer and the joining .csv file. Everything is formatted right in the joining .csv, I think - no blank rows or columns, no formatting at all, actually. What am I doing wrong?

Re: Simple Attribute Join Error: "Resulting Table Has No Rows"

DanPatterson_Retired — Thu, 16 Nov 2017 22:40:31 GMT

Try to convert the csv to a geodatabase table prior to doing the join to ensure that everything that could be done to produce an acceptable table has been done.

Re: Simple Attribute Join Error: "Resulting Table Has No Rows"

GraceVan_Horn — Fri, 17 Nov 2017 14:22:28 GMT

Thank you! I did that, but got the same result. When I run the Join Validation (now using slightly different attribute titles - I was worried the FID was part of the error), I get the following response: "The number of matching records for the join: - No matches found by joining [GEOID] from <0> with [AFFGEOID] from <County_Designations.csv>. I'm wondering if the problem is with the original layer, which is not named "0" - it's 2016_US_Counties. I'm attempting to do the join through that layer's attribute table, but is it possible it's not searching the right data from that layer?

Re: Simple Attribute Join Error: "Resulting Table Has No Rows"

DanPatterson_Retired — Fri, 17 Nov 2017 20:02:35 GMT

sounds like we need to see a screen shot of the tables