Limiting data in a LOAD-statement

[#1]

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.

[#2]

Thanks a lot, guys. The (qvd) hint was it.

Unfortunately I can't mark all your usefull tips. Sorry for that.

[#3]

see my first post.....where i mentioned qvd(qvd)....

and u replied; "I tried both before."

pls read the answer carefully before saying that u've tried....it wastes time and creates confusion....

[#4]

Sorry, my answer was correct, but not precise enough.

if it is string u need to use LABELNR='33271'

What I tried was both, with and without quotation marks.