This content has been marked as final. Show 7 replies
Wondering if I can do a nested select SQL statement in QLikview script... Qlikview seems grouchy though, however, I'm certain my syntax is not correct...
I have a QlikView file:TEMPFILE with only one "SchoolCode" field that contains distinct SchoolCode values.
I want to LOAD new data from a database... using only data with SchoolCodes that are in the tempfile...
LOAD * From DBO.TABLENAME
WHERE SchoolCodes IN (select distinct SchoolCode from TEMPFILE)
What am I doing wrong?