Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
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