topic Nested load resident/from qvd file like nested select statement in QlikView

Nested load resident/from qvd file like nested select statement

Mon, 14 May 2012 22:27:26 GMT

Hi All

Instead of a nested select statement such as select * from table 1 where name IN (select title from table2), how can I do that with resident tables or load from qvd files?

I know from a previous posting I can use Match instead of the In but I don't know how to do a nested select statement.

Thanks

Nested load resident/from qvd file like nested select statement

Oleg_Troyansky — Tue, 15 May 2012 01:18:58 GMT

Jack,

QlikView doesn't support nested LOADs. You can use WHERE exists() as a workaround for the IN (SELECT ...) logic. Also, look at the keyword KEEP, it might give you what you are looking for...

best,

Oleg