Importing from CSV

djsampat — Wed, 25 Nov 2020 16:16:04 GMT

Hope this helps anyone having any format issues with number columns after importing data from a csv file.

The data was being imported as text instead of numbers and I even tried using num(column) as number and it still did not work.

I realised that you need to turn off "Quoting" and select the "Ignore EOF box"

In the file wizard, check the Ignore EOF box and set Quoting to "None".

It should end up looking like this:-

CSVData:

LOAD

FROM

File.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', no quotes, no eof);

topic Importing from CSV in QlikView