LOAD certain records

[patrickbender]

Hi all,

I Want to load certain records from a CSV file and searching for it online gave me this on QV help page(Link‌):

Load only records where the field Litres has a value above zero:

LOAD * from Consumption.csv where Litres>0;

So I wrote this code but it doesn't seem to work and after i wrote the "WHERE" statemment it can't even locate the file.

LOAD

     [FCHACC_Konteringsbegrepp] as Kontonr,

    [FCHACC_SpärratKonteringsbegrepp] as KontoSpärr,

     [FCHACC_Beskrivning] as KontonNamn

FROM WHERE [FCHACC_Konteringsdimension]= 1

[niclaz79]

Hi, do you have a semicolon after your where-statement? I can't see anything else that is wrong.

[niclaz79]

Actually, I see that your file name has a semicolon in it. Is that supposed to be there?

Konteringsbegrepp_B;YG.csv

[patrickbender · Accepted solution]

End Result:

LOAD [FCHACC_Konteringsbegrepp] as Kontonr,

    [FCHACC_SpärratKonteringsbegrepp] as KontoSpärr,

    [FCHACC_Beskrivning] as KontonNamn

FROM

//missed to use this row so the sqript couldnt read the data correctly

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

WHERE [FCHACC_Konteringsdimension]= 1;

[patrickbender]

Thank you for your help

Located a missing row as well on how to read the csv file that ended up solving my problem