Skip to main content
Announcements
Meet the 2024 Qlik Luminaries and Partner Ambassadors! READ ON!
cancel
Showing results for 
Search instead for 
Did you mean: 
sangland2
Partner - Creator
Partner - Creator

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
Frank_Hartmann
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 ',')

sangland2
Partner - Creator
Partner - Creator
Author

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