Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Incomplete load of CSV files

When loading a CSV file using:(txt, codepage is 1252, embedded labels, delimiter is ',', msq)  the load stops before it reaches the end of the file. There is no error but not all the data is loaded. This is because text fields in the file have not been quoted, as they should, so the number of fields being loaded is different when it hits this line. An error should be thrown, surely? 

11 Replies
Highlighted
Master II
Master II

did you look in my first post?

please change this line in your script:

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

to

(txt, codepage is 1252, embedded labels, delimiter is ',')

Highlighted
Partner
Partner

The customerOrderNomber column has a single " character in line 33446 and again in 37154. Rows between are not loaded.