Empty Columns on Importing with CSVs

[induviduality]

I'm trying to import data from a CSV file. On Previewing the data, it seems like all the columns are correctly read.

However, after importing the data, some of the columns are blank. How do I resolve this?
Here is the dataset I'm using, for reference: https://opendata.arcgis.com/datasets/726277c507ef4914b0aec3cbcfcbfafc_0.csv

[harinij]

Hi @induviduality just checking, while importing did you use the Document ids to be autogenerated one or pick a column (and if so which column)?

[induviduality]

I picked the column named 'ID' in the dataset as the ID Column. One more thing I did was that I did not import the FID column in that dataset.

I tried deleting everything and importing the file multiple times, and the exact same columns are left blank once the import is done.

[iamanishroy]

Hi @induviduality,
I tried importing on my end and it worked fine.

Although I discovered a few empty cells in those columns, this was due to the CSV itself not having it.

I believe you will find some if you scroll down and look.

[induviduality]

Oh wow, I totally missed that. Thank you so much!
Sorry for the inconvenience caused

[iamanishroy]

Not a problem.