exclude id

[beck_bakytbek]

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

[sunny_talwar]

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);

[beck_bakytbek]

Hi Sunny, Thanks a lot for your feedback

look at this, i tried but i dont have an expected result

[sunny_talwar]

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;

[beck_bakytbek]

i tried, bit it does not work

[sunny_talwar · Accepted solution]

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;

[beck_bakytbek]

Thanks a lot Sunny for your help and sharing of your experience

i appreciate it

Thanks a lot  and have a nice day