topic Re: Viewing CSV Data in ArcPro in ArcGIS Pro Questions

Viewing CSV Data in ArcPro

KrishnaTiwari — Wed, 15 Jun 2022 13:12:42 GMT

Hello,

I'm currently trying to view CSV data in ArcPro and eventually join the data to another layer. However, when I try and view the CSV data in ArcPro I get the following message:

Failed to open table.

Error: The value type is incompatible with field type [Zip_Code]

Does this mean there are errors in the Zip_Code field column, or something else? Thank you for the help!

Re: Viewing CSV Data in ArcPro

Jon-PaulMcCool — Wed, 15 Jun 2022 13:17:37 GMT

If you added the CSV it would be easier to answer your question, but I could see it being that:

-there are rows with bad values

-that the field is being read as something other than numeric

-the Field is numeric but something other than numeric is stored in the field.

Would need to see the csv to know.

Re: Viewing CSV Data in ArcPro

RobertBorchert — Wed, 15 Jun 2022 17:09:30 GMT

Check the zip code field and see if all the zip codes are zip codes

Re: Viewing CSV Data in ArcPro

GregCarlino2 — Tue, 21 Jun 2022 16:27:09 GMT

I've run into problems with importing ZIP codes, as well. In my case, it was because spreadsheet contained data from NJ, where the ZIP codes begin with '0'. When I imported into ArcMap as a numerical data type, it was truncating the the leading '0' and importing as a 4-digit number, which was then unrecognizable as a ZIP. Any chance your ZIPs start with '0'? If so, try importing as a text data type.