Filter on QVD load.

Anonymous — Mon, 07 Jan 2013 17:00:33 GMT

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

];

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 ...

Re: Filter on QVD load.

Anonymous — Mon, 07 Jan 2013 17:16:13 GMT

Table1:

LOAD * INLINE [

];

Table2:

NoConcatenate

LOAD * INLINE [

] 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?