topic Re: Error joining csv file to feature class in ArcGIS Pro Questions

Error joining csv file to feature class

DVP — Tue, 03 May 2022 06:32:53 GMT

Hello, as the title says I am trying to join a CSV file to a feature class and I keep getting an error 999999. At first, I thought it was because field types were different so once I had them matching up properly I assumed the join would go through, but I still get the same error. It should be a fairly simple join so I am not sure what I am missing that is causing this error to come up. I would appreciate any advice on the matter.

Re: Error joining csv file to feature class

DanPatterson — Tue, 03 May 2022 09:28:15 GMT

show your inputs. it could be something with a particular column or a row.

Try making the csv into a geodatabase table first, then try the join is another option

Re: Error joining csv file to feature class

RobertBorchert — Tue, 03 May 2022 12:29:52 GMT

If you are trying to join string fields together make sure your .csv file does not have a length greater than 255

If it does then technically even though it is still a string but it is a type not supported. One way to determine that is to import the .csv into a database and look at the properties. .csv fields can have up to 32767 characers.

Re: Error joining csv file to feature class

GoWest — Sun, 18 Dec 2022 09:56:38 GMT

Like DanPatterson said, add your csv to the Contents pane and then immediately export it to a geodatabase table. Joining a Feature Class to a csv file directly is prone to errors, which is why everyone recommends exporting the csv to a geodatabase table. If you join a Feature Class to a csv and check the "Index Joined Fields" checkbox, you will always get a ERROR 999999.

It would be nice if we had better error messages when joining Feature Class to a csv. ESRI should disable the ability to join Feature Class to csv altogether. Having a right click option to import CSV to Geodatabase table quickly would be a nice alternative.

@KoryKramer

Re: Error joining csv file to feature class

JonathanNeal — Wed, 28 Jun 2023 01:58:37 GMT

FYI, added a validation error to let users know text files do not support indexing. I hope this helps for users in 3.2+