CSV not loading all rows

[#1]

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

[alexandros17 · Accepted solution]

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

[#3]

try

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