pull data from a QVD using a list of filtered values

[niha]

Hello,

I need answer of the question below.

1. Show us the most efficient way to pull data from a QVD using a list of filtered values

Regards,

Niha

[lironbaram]

hi 

your most efficient method will be 

to load a table with the values list 

than use exists in the QVD call , that way the qvd load will stay optimized 

if we assume Field1 is the field you use to filter .

your script should look like this : 

filterTable:

load Filed1

From filterList

Fact :

load *

from fact.qvd

where exists(Field1);

[niha]

Thanks. I am able to understand second part where exist function but I am bit confused with first one. If we are calling  fact qvd with where exist function, the way it should be done is as follows:

1, Pull fact table and then convert to qvd. 

What is load a Table with valued list? 

Sorry I need to understand the first part.

Regards,

Niha