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?

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
    Nov 2, 2023 at 19:29
  • 2
    Could you share couple of rows source data?
    – user30184
    Nov 2, 2023 at 19:40
  • 1
    Can you please show your .csvt ?
    – Taras
    Nov 2, 2023 at 20:49

1 Answer 1

3

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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