CSV not loading all rows

Fri, 13 Jun 2014 08:51:23 GMT

Hi i've a csv file with 3280 lines + headers = 3281 lines, but my script is only loading 2556 for no reason.

My csv is utf8 i've checked in notepad++ , and i've created a var to display the total of rows in a text Object.

My script:

PF_DATA:

LOAD Year,

Week,

RaisedDate,

id,

UPPER(RaisedBy) as RaisedBy,

UPPER(sFrom) as sFrom,

sFromName,

UPPER(sTo) as sTo,

sToName,

MOD,

REA,

UPPER(Responsible) as Responsible,

Auth,

Val as Currency,

ST,

Category,

Reason,

ProgramName,

UPPER(RaiserPlant) as RaiserPlantID,

UPPER(Haulier) as Haulier

FROM

[..\External Sources\EPG_Freight\Rpt_Lamas_Qtest.csv]

(txt, utf8 , embedded labels, delimiter is ',')

WHERE

UPPER(RaiserPlant) = '351E' OR

UPPER(RaiserPlant) = '179A' OR

UPPER(RaiserPlant) = '179B' OR

UPPER(RaiserPlant) = '1215' OR

UPPER(RaiserPlant) = 'ALTAA' OR

UPPER(RaiserPlant) = '295A' OR

UPPER(RaiserPlant) = '604E' OR

UPPER(RaiserPlant) = '6605' OR

UPPER(RaiserPlant) = '710A' OR

UPPER(RaiserPlant) = '710B' OR

UPPER(RaiserPlant) = '6865' OR

UPPER(RaiserPlant) = '1225'

;

LET vNoOfRows = NoOfRows('PF_DATA');

Re: CSV not loading all rows

alexandros17 — Fri, 13 Jun 2014 08:58:07 GMT

I'm quite sure that there are some RaiserPlant codes not recognized and so discarted in your where condition.

To verify this, execute the Load without the where conditions and check numbers of rows

let me know

Re: CSV not loading all rows

Mon, 11 Aug 2014 13:37:45 GMT

try

(txt, utf8, embedded labels, delimiter is ';', no quotes);

topic Re: CSV not loading all rows in QlikView

CSV not loading all rows

Re: CSV not loading all rows

Re: CSV not loading all rows