Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
djsampat
Creator II
Creator II

Importing from CSV

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);

0 Replies