Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
i have such issue:
tab1:
Load * inline [
ID, Value
1, 10
2, 15
];
tab2:
Load * inline [
ID, Value
2, 5
]
Where not Exists(ID);
my question is:
i want exclude only ID =2 , my expected output is: table with only: ID =1, Value = 10,
i can solve this by creating of where ID <> '2', but i want to know, whether is another method to exclude values and how can i exlude these value dynamic.
thanks a lot
beck
My bad, try this.... this should work
tab2:
Load * inline [
ID, Value
2, 5
];
tab1:
NoConcatenate
Load * inline [
ID, Value
1, 10
2, 15
]
Where not Exists(ID);
DROP Table tab2;
Then you need to do this
tab2:
Load * inline [
ID, Value
2, 5
];
tab1:
Load * inline [
ID, Value
1, 10
2, 15
]
Where not Exists(ID);
Hi Sunny, Thanks a lot for your feedback
look at this, i tried but i dont have an expected result
I think you need to drop the table tab2 after this
tab2:
Load * inline [
ID, Value
2, 5
];
tab1:
Load * inline [
ID, Value
1, 10
2, 15
]
Where not Exists(ID);
DROP Table tab2;
i tried, bit it does not work
My bad, try this.... this should work
tab2:
Load * inline [
ID, Value
2, 5
];
tab1:
NoConcatenate
Load * inline [
ID, Value
1, 10
2, 15
]
Where not Exists(ID);
DROP Table tab2;
Thanks a lot Sunny for your help and sharing of your experience
i appreciate it
Thanks a lot and have a nice day