Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need answer of the question below.
Regards,
Niha
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);
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