Where Exists clarification - QVD optimized while field is concatenated

[vkish16161]

Temp:

load * inline [

Country_Year_Exists

USA-2015

IND-2018];

FACT:

load * inline [

Country,Year,Sales

USA,2015,100

USA,2016,200

IND,2018,150

IND,2019,200

GBP,1991,100]

where Exists(Country_Year_Exists,Country&'-'&Year);

Can someone explain if this'll still retain the Optimized QVD load?

hic‌ rwunderlich‌

[marcus_sommer · Accepted solution]

Only with a single parameter will a where exists(FIELD) keep a qvd-load optimized and everything else will force a processing of the data and therefore an unoptimized load.

- Marcus