Filter on QVD load.

[Anonymous]

Hello,

I have some problem with implementation of conditional load based on QVD file. I tried  match, exists but they seems to work wrong...

QVD_FULL:

LOAD * INLINE [

          CUSTOMER, REGION, VAL

          Adam, 1 , 100

          Mark ,  2 ,  300

          Zahar,  2, 300

          Rafael, 3, 330

          Mark ,  4 ,  300

          Zahar,  4, 300

          Rafael, 6, 330

];

STORE QVD_FULL INTO  QVD_FULL_EXTRACT.qvd(qvd);

QVD_FILTER:

LOAD * INLINE [

          FILTER

          2

          3

];

QVD_FILTRED:

LOAD * FROM 

          QVD_FULL_EXTRACT.qvd

WHERE

/* this is what i want :  REGION NOT IN ( QVD_FILTER.FILTER ) */

Anyone can help me with that ?

I know that there is a possibilty to use concatenate and NOT EXISTS but It doesn't work ...

[Anonymous]

Table1:

LOAD * INLINE [

          ID

          1

          2

];

Table2:

          NoConcatenate

          LOAD * INLINE [

          ID

          2

          3

          4

] WHERE NOT EXISTS(ID);

DROP TABLE Table1;

Got it: DROP STATEMENT IS VERY IMPORTANT

Well still got problem with that:

It looks like NOT EXISTS is badly implemented.  When I select  

EXISTS(ID)  and DROP statement I can get 2 and it works fine even when we have duplicated rows. But when I select NOT EXISTS

all matched rows are aggregated?! Why?