Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
VishalWaghole
Specialist II
Specialist II

Exists Function

Hi Community,

I have little doubt about Exists Function.

I have

table1 which contain Number Column having Data as

Num

1

2

3

table2 which contain Number Column having Data as

Num

1

2

3

4

5

6

7

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

Thanks

1 Solution

Accepted Solutions
Not applicable

see attachement

Table1:

LOAD * INLINE [

    Num

    1

    2

    3

];

Right Join

Table2:

LOAD * INLINE [

    Num

    1

    2

    3

    4

    5

    6

    7

] Where not Exists(Num);

View solution in original post

4 Replies
Not applicable

try this format--

zgate:

LOAD * INLINE [

    id

    3

    4

];

Right Join

mseg:

LOAD * INLINE [

    id

    1

    2

    3

    4

] Where not Exists(id);

Not applicable

also try this

mseg:

LOAD *, id1 as id INLINE [

    id1

    1

    2

    3

    4

];

Right Join

zgate:

LOAD * INLINE [

    id,name

    3,a

    4,b

    5,c

] Where not Exists(id);

Not applicable

see attachement

Table1:

LOAD * INLINE [

    Num

    1

    2

    3

];

Right Join

Table2:

LOAD * INLINE [

    Num

    1

    2

    3

    4

    5

    6

    7

] Where not Exists(Num);

View solution in original post

VishalWaghole
Specialist II
Specialist II
Author

Thanks Vishwarajan