Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
try this format--
zgate:
LOAD * INLINE [
id
3
4
];
Right Join
mseg:
LOAD * INLINE [
id
1
2
3
4
] Where not Exists(id);
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);
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);
Thanks Vishwarajan