topic Optomized load not working in QlikView

Optomized load not working

vvvvvvizard — Thu, 24 Aug 2017 12:14:45 GMT

Why is this not an optimzed load , if i comment out the the where statement it is , if i add it to load on year 2014 ,2015, 2016 , 2017 , it loads those years but not in an opmized load ?

Temp_dates:
LOAD * Inline [
FIN_JAAR
2014
2015
2016
2017
];

"MAANDEINDE BALANSE":
load

[FIN JAAR]

from $(DATA_QVD)maandeindebalanse.qvd (qvd) where Exists(FIN_JAAR,[FIN JAAR]);

DROP Table Temp_dates;
EXIT Script;

Re: Optomized load not working

sunny_talwar — Thu, 24 Aug 2017 12:19:02 GMT

Try this

Temp_dates:
LOAD * Inline [
FIN JAAR
2014
2015
2016
2017
];

"MAANDEINDE BALANSE":
LOAD [FIN JAAR]
FROM $(DATA_QVD)maandeindebalanse.qvd (qvd)

Where Exists([FIN JAAR]);

UPDATE: Made changes based on Tresesco's comments below...

Re: Optomized load not working

tresB — Thu, 24 Aug 2017 12:24:33 GMT

Or, perhaps it's other way around (field name).

Temp_dates:
LOAD * Inline [
"FIN JAAR"
2014
2015
2016
2017
];

"MAANDEINDE BALANSE":
LOAD [FIN JAAR]
FROM $(DATA_QVD)maandeindebalanse.qvd (qvd)

Where Exists([FIN JAAR]);

To keep it optimized, exists() has to be used with single-field.

Re: Optomized load not working

sunny_talwar — Thu, 24 Aug 2017 12:25:42 GMT

Ya, I did not see the names were different

Re: Optomized load not working

sunny_talwar — Thu, 24 Aug 2017 12:27:29 GMT

I won't put square brackets in my inline load