Where exists clause in script

[#1]

Hi there,

Currently I have two scripts, one containing fact-tables and the second containing relevant dimensions of these facts. In my fact-script I have made a where clause that filters out observations that is not relevant. Therefore I would to perform a where exists load on my dimensions, in order to not just load every single dimension value. Currently I have tried the following syntax:

LIB CONNECT TO ...;

LOAD *;

SQL SELECT *

FROM EDW.qs.vDimCustomerSellTo where exists (vDimCustomerSellto);

I only want to load CustomerSellTo-values that are represented in my fact-tables.

All my fact-tables are loaded correct, however the statement above does not seem to work for me, does any of you know why?

Thank you in advance.

Nicolai

[#2 · Accepted solution]

Hi Nicolai,

The where exists clause should be in the load statement

LOAD * where exists (vDimCustomerSellto);

SQL SELECT * FROM EDW.qs.vDimCustomerSellTo;

Should work.

Regards

Huub

[sasiparupudi1]

exitsts is a qlikview function and it can only be used in for qlikview tables.. for sql you have to use your normal where conditions

hth

Sasi

[Digvijay_Singh]

You may try preceding load or resident load with Exists clause  to filter the record once loaded from source(without exists clause) or filter them at source only.

[#5]

Thanks Huub! That works perfect (Y)

Regards

Nicolai