topic LOAD certain records in QlikView

LOAD certain records

patrickbender — Fri, 04 May 2018 07:25:02 GMT

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 — Fri, 04 May 2018 07:33:31 GMT

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

niclaz79 — Fri, 04 May 2018 07:34:33 GMT

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

Konteringsbegrepp_B;YG.csv

patrickbender — Fri, 04 May 2018 07:41:57 GMT

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 — Fri, 04 May 2018 07:43:18 GMT

Thank you for your help

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