topic Re: WHERE Exists in QlikView

WHERE Exists

srinivasa1 — Thu, 29 Nov 2012 17:26:33 GMT

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

LOAD

EMP_CODE AS EMPCODE,

NAME

FROM A.QVD

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

prieper — Thu, 29 Nov 2012 17:27:59 GMT

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

HTH
Peter

MayilVahanan — Thu, 29 Nov 2012 17:32:06 GMT

LOAD

EMP_CODE AS EMPCODE,

NAME

FROM A.QVD;

load

EMP_CODE AS EMPCODE,

dept

WHERE Exists (EMPCODE, EMP_CODE);

SQL SELECT *FROM B;

Hope it helps

srinivasa1 — Thu, 29 Nov 2012 18:21:23 GMT

yes your right thanks