Where filter from colA in table B

[Anonymous]

hi all,

i need to use filter in TableA for col1 from TableB. Means whatever the items is there in col1 tableB only those items should not appear in TableA. Please advise, thanks

TableA:

col1,

col2,

col3

from A

TableB:

col1,

col12,

[Anonymous]

Hi Srividhya,

Please share sample data and expected output.

[Anonymous]

Hi Mahesh

i have attached the sample in abv. plz refer. thanks

[Anonymous]

Hi Srividhya,

Please find the attachment. Hope it helps you.

[Anonymous · Accepted solution]

Sorry, I am unable attach a file . please use below code

Table:

LOAD * INLINE [

    T1, T2, T3

    Apple, 10, 3

    Mango, 30, 6

    Orange, 56, 2

    Grape, 23, 7

    Kiwi, 65, 3

];

Table1:

LOAD * INLINE [

    A1, A2, A3

    Orange, 56, 2

    Kiwi, 65, 3

];

test:

Load  * ,1 as Demo   Resident Table where not Exists(A1,T1);

drop Tables Table,Table1;

[Anonymous]

Check the attachment