I have a CSV file with four columns. The first column is text, and the succeeding columns are percentages. I have set up a csvt file with "String", "Integer", "Integer", "Integer"
When I import the file into QGIS as a delimited text layer, QGIS strips out all the percentages. They come in as null values.
LGA_NAME Non-Indigenous Aboriginal Torres Strait Islander
Albury (C) 93% 2% 0%
Armidale Dumaresq (A) 88% 6% 0%
Ashfield (A) 93% 1% 0%
Auburn (C) 93% 1% 0%
Ballina (A) 93% 3% 0%
Balranald (A) 87% 6% 0%
Bankstown (C) 94% 1% 0%
Bathurst Regional (A) 91% 4% 0%
Bega Valley (A) 93% 3% 0%
Bellingen (A) 94% 3% 0%
Berrigan (A) 94% 2% 0%
The three headings are Non-Indigenous, Aboriginal, Torres Strait Islander.
Best Answer
Your numbers still contain the "%" symbol. If you want them to be recognized as numbers then loose the "%". i.e.:
Also be sure you are choosing the semicolon ";" as the "Custom delimiter" when you do the import.