Select to view content in your preferred language

CSV table is missing records in Feature Layer

06-29-2023 02:20 PM
New Contributor

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.

Tags (3)
3 Replies
Occasional Contributor III

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.

0 Kudos
Occasional Contributor III

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.

0 Kudos
Esri Contributor

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

0 Kudos