Where exist not working

[Luffy1994]

Hi All,

i am not able to understand the why script is not loading in optimized way, below is my sciprt

temp_id:
LOAD * INLINE [
appid
0
];

load Id

from abc.qvd

where exist (appid);

where appid is present in abc.qvd

the script is filtering the data but not in optimized way

[Or · Accepted solution]

Load Id, appid

from qbc.qvd

Where exists(appid);

You need the exists() field in your load if you want an optimized load, I believe.

[Anonymous]

Does appid exist in the qbc.qvd, or does id = appid? If the latter then the clause might be

where exists(appid,id).

HTH.

John

(aka jpohncaqc)