Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
vvvvvvizard
Partner - Specialist
Partner - Specialist

Optomized load not working

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;

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

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

View solution in original post

4 Replies
sunny_talwar
MVP
MVP

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

tresB
Champion III
Champion III

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

Ya, I did not see the names were different

sunny_talwar
MVP
MVP

I won't put square brackets in my inline load