topic Re: exclude id in QlikView

exclude id

beck_bakytbek — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: exclude id

sunny_talwar — Tue, 21 Mar 2017 12:42:08 GMT

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

Re: exclude id

beck_bakytbek — Tue, 21 Mar 2017 12:51:25 GMT

Hi Sunny, Thanks a lot for your feedback

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

Re: exclude id

sunny_talwar — Tue, 21 Mar 2017 12:57:00 GMT

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;

Re: exclude id

beck_bakytbek — Tue, 21 Mar 2017 13:00:27 GMT

i tried, bit it does not work

Re: exclude id

sunny_talwar — Tue, 21 Mar 2017 13:07:48 GMT

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;

Re: exclude id

beck_bakytbek — Tue, 21 Mar 2017 13:11:53 GMT

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

i appreciate it

Thanks a lot and have a nice day