Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
patrickbender
Contributor III
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
Contributor III
Contributor III
Author

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
niclaz79
Partner - Creator III
Partner - Creator III

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

niclaz79
Partner - Creator III
Partner - Creator III

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

Konteringsbegrepp_B;YG.csv

patrickbender
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

Thank you for your help

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