Exists Function

[VishalWaghole]

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

[#2]

try this format--

zgate:

LOAD * INLINE [

    id

    3

    4

];

Right Join

mseg:

LOAD * INLINE [

    id

    1

    2

    3

    4

] Where not Exists(id);

[#3]

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);

[#4 · Accepted solution]

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);

[VishalWaghole]

Thanks Vishwarajan