Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

srinivasa1
Contributor

WHERE Exists

This could be unintelligent question still I need to do.

I have  two table like
A and B

Here A is QVD and B Is direct connected Db and  trying use where exists like below

A:

LOAD

EMP_CODE AS EMPCODE,

NAME

FROM A.QVD

B:

load

EMP_CODE AS EMPCODE,

dept

SQL SELECT *FROM  B

WHERE(Exists EMPCODE, EMP_CODE);

WILL IT WORK ,IHAVE TRIED BUT ITS NOT WORKING PLS GUIDE ME

Thanks

Tags (2)
1 Solution

Accepted Solutions

Re: WHERE Exists

HI

A:

LOAD

EMP_CODE AS EMPCODE,

NAME

FROM A.QVD;

B:

load

EMP_CODE AS EMPCODE,

dept

WHERE Exists (EMPCODE, EMP_CODE);

SQL SELECT *FROM  B;

Hope it helps

3 Replies
prieper
Honored Contributor II

Re: WHERE Exists

The EXISTS-command belongs to QlikView, not SQL. Thus should be put in a preceding load over the SQL-statement.

HTH
Peter

Re: WHERE Exists

HI

A:

LOAD

EMP_CODE AS EMPCODE,

NAME

FROM A.QVD;

B:

load

EMP_CODE AS EMPCODE,

dept

WHERE Exists (EMPCODE, EMP_CODE);

SQL SELECT *FROM  B;

Hope it helps

srinivasa1
Contributor

Re: WHERE Exists

yes your right thanks

Community Browser