topic Re: QVD Where Clause WHERE NOT in QlikView

QVD Where Clause WHERE NOT

Mon, 15 Jul 2013 20:26:43 GMT

Howdy!

So I am loading data from a QVD and I want to exclude rows if either one or both of these are true: ITEM_NBR LIKE '%PLT%' or INV_ITEM_ID LIKE '%MISC%'. It seems that NOT LIKE doesn't work when loading from a QVD?

Directory;

ORDERS:

LOAD

ORDER_NO,

ITEM_NBR,

ITEM_QTY,

ITEM_COST,

ITEM_DESC,

ITEM_CLASS

FROM

[..\ORDERS_*.QVD]

(qvd)

WHERE

AND ITEM_NBR NOT LIKE '%PLT%'

AND INV_ITEM_ID NOT LIKE '%MISC%'

What are my options and does it tell me somewhere what the QVD LOAD where clause differences are? I'm sure it's something silly that I'm missing but drawing a blank here...

Thanks!

Re: QVD Where Clause WHERE NOT

swuehl — Mon, 15 Jul 2013 20:51:50 GMT

Try like this

Directory;

ORDERS:

LOAD

ORDER_NO,

ITEM_NBR,

ITEM_QTY,

ITEM_COST,

ITEM_DESC,

ITEM_CLASS

FROM

[..\ORDERS_*.QVD]

(qvd)

WHERE

NOT ITEM_NBR LIKE '*PLT*'

AND NOT INV_ITEM_ID LIKE '*MISC*';

Re: QVD Where Clause WHERE NOT

Sokkorn — Tue, 16 Jul 2013 01:49:07 GMT

Hi Sir,

Found something wrong in your where clause. Let try this:

Directory;

ORDERS:

LOAD

ORDER_NO,

ITEM_NBR,

ITEM_QTY,

ITEM_COST,

ITEM_DESC,

ITEM_CLASS

FROM

[..\ORDERS_*.QVD]

(qvd)

WHERE Not WildMatch(ITEM_NBR,'*PLT*') and Not WildMatch(INV_ITEM_ID,'*MISC*');

Regards,

Sokkorn

Re: QVD Where Clause WHERE NOT

Tue, 16 Jul 2013 12:36:29 GMT

Thanks! I'll give the WildMatch a try as well, always good to have options