Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Hi, do you have a semicolon after your where-statement? I can't see anything else that is wrong.
Actually, I see that your file name has a semicolon in it. Is that supposed to be there?
Konteringsbegrepp_B;YG.csv
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;
Thank you for your help
Located a missing row as well on how to read the csv file that ended up solving my problem