what is wrong with where condition of a simple code ?

[prahlad_infy]

Hello Sirs ,

I am not understand the wrong with below code . All i want to remove certain rows while loading fro qvd . But where conition not working .

Table1:

LOAD * INLINE [

    A1, B1, C1

    Unkown, QX, 5001

    Unkown, 1A, 5001

    Unkown, 2A, 5001

    AB1, 3A, 5001

    AB2, 4A, 5001

    AB3, 5A, 5001

    AB4, 1A, 5001

    AB5, QX, 5001

    AB6, QX, 5002

    AB7, 1A, 5003

    AB8, 2A, 5004

    AB9, 3A, 5005

    Unkown, 4A, 5006

    Unkown, 5A, 5007

    AB12, 1A, 5008

    AB13, QX, 5009

    AB14, QX, 5010

    AB15, 1A, 5011

    AB16, 2A, 5012

    AB17, 3A, 5013

    AB18, 4A, 5014

    AB19, 5A, 5015

    AB20, 1A, 5016

    AB21, QX, 5017

    Unkown, QX, 5018

    Unkown, 1A, 5019

    AB24, 2A, 5020

    AB25, 3A, 5021

];

STORE Table1 into C:\Users\xxxxxxx\Desktop\xxxxxxx\xxxxxxxxxx\Table1.qvd ;

DROP Table Table1 ;

Table2:

LOAD A1,

     B1,

     C1

FROM

(qvd) Where not WildMatch(A1,'Unkown') or not WildMatch(B1,'QX') ;

Please help sir .

[trdandamudi]

If that is the case, you can still use the below code without wildmatch:

Table2:
LOAD A1,
B1,
C1
FROM
(qvd)
Where Not (A1 Like '*Unkown*' or B1 = 'QX') ;

Hope this helps.