Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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...
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...
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.
Ya, I did not see the names were different
I won't put square brackets in my inline load