Not Exist issue

[brijesh1991]

Hi All,

I have two two tables. First table contains 30 IDs, second Table contains 100 IDs. I don't want those 30 IDs in my Dashboard.

So I use Not Exist function. Will you suggest is there any wrong with it?

My script demo:

Table1:

Load ID from Table1;

Table2:

Load ID from Table2 where not exist(ID);

drop table Table1;

[luciancotea]

Table1:

Load ID as ID_BAD from Table1;

Table2:

Load ID from Table2 where not exist(ID_BAD, ID);

drop table Table1;

[brijesh1991]

Hi Cotea,

Thanks. . . Not exists not working.. It's giving me 100 IDs only.

[luciancotea · Accepted solution]

This works:

Table1:

LOAD * INLINE [

    ID_BAD

    1

    2

    3

];

Table2:

LOAD * INLINE [

    ID

    1

    2

    3

    4

    5

    6

    7

    8

    9

    10

]

where not exists(ID_BAD, ID);

drop table Table1;

The result will be the numbers from 4 to 10.

[sujeetsingh]

can also write as

where ID<>null()

[brijesh1991]

Thanks Lucian Kotea... It worked....

When I was taking tables directly, it wasn't working.... then I take resident of the same and both tables need to force 'noconcate', then it's working fine...

Your answer is absolutely correct!

Thanks Brother!