topic Re: CSV table is missing records in Feature Layer in ArcGIS Online Questions

CSV table is missing records in Feature Layer

JordanWeinberg1 — Thu, 29 Jun 2023 21:20:33 GMT

I've uploaded a CSV file with 1,675 records but for some reason only 1,624 show.

I've uploaded it multiple times but it is stuck on 1,624 even though the file itself clearly shows 1,675.

Re: CSV table is missing records in Feature Layer

DavidSolari — Thu, 29 Jun 2023 22:05:22 GMT

Does every row in the CSV have a unique ID of some sort? Export what you have in AGOL and isolate the missing records and see if there's some notable difference between them and the successful records. You might have to open the file in a text editor to see exactly how the data is stored.

Re: CSV table is missing records in Feature Layer

clt_cabq — Thu, 29 Jun 2023 22:27:10 GMT

I would hazard a guess that there is something not right with the coordinates for those missing 51 records. One approach you could use is to join the spatial layer back to your original .csv - rows with nulls showing on the spatial layer side of the join will be your missing .csv values and you can look at the coordinates in that context.

Re: CSV table is missing records in Feature Layer

ChrisUnderwood — Fri, 30 Jun 2023 14:46:07 GMT

@JordanWeinberg1 If you are able, you could post your .CSV here for us to look at.