Optomized load not working

[vvvvvvizard]

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;

[sunny_talwar · Accepted solution]

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...

[tresesco]

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.

[sunny_talwar]

Ya, I did not see the names were different

[sunny_talwar]

I won't put square brackets in my inline load