Hi All ,
I have a qvd where in i need only few records related to the field,Country=INDIA .
There are multiple values in the field COUNTRY like INDIA,US,AUS etc.
In my dashboard,i have to load only INDIA related data .
I followed the below approach to filter the INDIA data and make the load as optimized load .
load * inline
Load * from QVDfile where exists(Country) ;
i created one inline so that i can use exists function while loading qvd .
This will make the load as optimized load and if i use where Country=INDIA,it will not be of optimized load .
Can anyone let me know is this the right way to do it ??