Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
patrickbender
New Contributor III

LOAD certain records

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

1 Solution

Accepted Solutions
patrickbender
New Contributor III

Re: LOAD certain records

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;

View solution in original post

4 Replies
Partner
Partner

Re: LOAD certain records

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

Highlighted
Partner
Partner

Re: LOAD certain records

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

Konteringsbegrepp_B;YG.csv

patrickbender
New Contributor III

Re: LOAD certain records

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;

View solution in original post

patrickbender
New Contributor III

Re: LOAD certain records

Thank you for your help

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