Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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;
Hi Srividhya,
Please share sample data and expected output.
Hi Mahesh
i have attached the sample in abv. plz refer. thanks
Hi Srividhya,
Please find the attachment. Hope it helps you.
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;
Check the attachment