3

I am importing a .csv file and one of the "integer" columns ("ZVH Density") is all NULL values when imported as a Delimited Text file. Whole numbers import (known through trial and error) but decimals (0.03333) do not.

enter image description here

I have set up a .csvt file to define the column as "Integer".

enter image description here

If I import the file as a Vector, the "ZVH Density" column imports, however, it is a String (which I don't want). What am I doing wrong here?

Improve this question
3
  • The question is confusing. "One of the "integer" columns (...) is all NULL values when imported (...) but decimals (0.03333) do not." How do you expect decimals to import into integer field?
    – Babel
    Commented Nov 2, 2023 at 19:29
  • 2
    Could you share couple of rows source data?
    – user30184
    Commented Nov 2, 2023 at 19:40
  • 1
    Can you please show your .csvt ?
    – Taras
    Commented Nov 2, 2023 at 20:49

1 Answer 1

Reset to default
3

You have a field length of 0, so nothing can be imported. Change field length to a large enough positive value.

Improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.