topic How to load optimized qvd with two where condition or more conditions in QlikView

How to load optimized qvd with two where condition or more conditions

sangeeth8787 — Wed, 02 Jan 2019 17:44:56 GMT

I have situation, one of the previous developer

created load script as Load * from x.qvd(qvd) where color = 'red' and year = 2018.

Because of two where conditions, the load is not optimized, how can we create the above load script with 2 conditions as optimized load. I have been searching in community but I haven't got much luck, could you please provide some hint on this scenario. Many Thanks in Advance

Re: How to load optimized qvd with two where condition or more conditions

sunny_talwar — Wed, 02 Jan 2019 18:00:37 GMT

Create a new field in your qvd which combines color and year into a new field

Table:
LOAD ...,
   color,
   year,
   color&'|'&year as key
FROM ...;

STORE Table into x.qvd (qvd);

now when you load this... create an inline load of what you wish to load....

Temp:
LOAD * INLINE [
Key
red|2018
];

and then load the qvd like this

LOAD *
FROM x.qvd (qvd)
Where Exists(key);

DROP Table Temp;