Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
When I select data from an ODBC-source, I can limit the selected data with the WHERE-clause.
I.e.:
SELECT *
from BI.example
where DATE > '01.01.2006';
I'd like to know the equivalent, if I LOAD data from a .qvd-file and only want to load data which match the given criteria, i.e. only one specific customer-ID. The WHERE-clause doesn't work in combination with LOAD, afaik.
I bet this is a simple thing but I didn't figure it out yet.
Don't forget to add (qvd) after .qvd...Ex: FROM Struktur\ARTIKEL.qvd(qvd)
Or else instead of writing the script, load it from Table Files.
This is what I do:
SHE:
LOAD ARTIKELNR,
LABELNR
FROM Struktur\ARTIKEL.qvd
where LABELNR = 33271;
The from-clause alone works this way.
I forgot to mention the error message. QV recognizes the where-statement as part of the filename and -path.
use:
LOAD ARTIKELNR,
LABELNR
FROM Struktur\ARTIKEL.qvd(qvd)
where LABELNR = 33271;
make sure the field LABRLNR is number.
if it is string u need to use LABELNR='33271'
I tried both before. As I said: problem seems to be that QV does interpret the where-statement as part of the filepath (see the error message screenshot).
I do not use a directory-statement to ensure that QV uses relative paths instead of absolutes. This works everywhere in the script but it seems as if it does not in this special case.
i understand English only.....so cant understand ur error mseg....
may be u can translate
Error opening file 'D:\Workarea\QVDs\Struktur\ARTIKEL.qvd where LABELNR = 33273' etc.
You can see at the quote signs that QV thinks of the whole expression as filename...
have you tried (qvd) after .qvd ?
have u used : FROM Struktur\ARTIKEL.qvd(qvd)
if yes......and it didn't work.....just delete ur script and use the 'Table files' button to select from ur qvd after checking the box 'Relative paths' and just remove the semi colon after the statememt generated and put the where clause.
Don't forget to add (qvd) after .qvd...Ex: FROM Struktur\ARTIKEL.qvd(qvd)
Or else instead of writing the script, load it from Table Files.