
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Where exists clause in script
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Huub! That works perfect (Y)
Regards
Nicolai
