topic Re: Exists Function in QlikView

Exists Function

VishalWaghole — Wed, 07 Aug 2013 07:08:49 GMT

Hi Community,

I have little doubt about Exists Function.

I have

table1 which contain Number Column having Data as

Num

table2 which contain Number Column having Data as

Num

and i want output like number which are not exists in table1 but exists in tabl2 by using Exists Function

Thanks

Re: Exists Function

Wed, 07 Aug 2013 07:33:11 GMT

try this format--

zgate:

LOAD * INLINE [

];

Right Join

mseg:

LOAD * INLINE [

] Where not Exists(id);

Re: Exists Function

Wed, 07 Aug 2013 07:36:03 GMT

also try this

mseg:

LOAD *, id1 as id INLINE [

id1

];

Right Join

zgate:

LOAD * INLINE [

id,name

3,a

4,b

5,c

] Where not Exists(id);

Re: Exists Function

Wed, 07 Aug 2013 07:41:27 GMT

see attachement

Table1:

LOAD * INLINE [

Num

];

Right Join

Table2:

LOAD * INLINE [

Num

] Where not Exists(Num);

Re: Exists Function

VishalWaghole — Wed, 07 Aug 2013 09:44:28 GMT

Thanks Vishwarajan