HELP excluding a certain value from a field

[aaronnayan]

HI in the script

LOAD BRNO AS LNK_BRNO,

  BRNO,

    BRENAME,

   RSMENAME,

   DSDENAME

FROM*********************************************(qvd)

WHERE EXISTS (LNK_BRNO,BRNO) AND (DSDENAME<>'CLOSED'

1. There is a value in the DSDENAME field column called CLOSED that i do not want to include into the script. Can anyone help me with this please?

[adamdavi3s · Accepted solution]

This should work?

LOAD *

WHERE DSDENAME<>'CLOSED';

LOAD BRNO AS LNK_BRNO,

  BRNO,

    BRENAME,

   RSMENAME,

   DSDENAME

FROM*********************************************(qvd)

WHERE EXISTS (LNK_BRNO,BRNO) ;

[sunny_talwar]

But why would this not work Adam?

LOAD BRNO AS LNK_BRNO,

  BRNO,

    BRENAME,

   RSMENAME,

   DSDENAME

FROM*********************************************(qvd)

WHERE EXISTS (LNK_BRNO,BRNO) AND (DSDENAME<>'CLOSED';

[adamdavi3s]

I wasn't aware you could mix where and where exists like that but of course you can, sorry I keep my QVD loads optimised so not a situation I've really messed with before

Maybe its just a case of an erroneous bracket then and this will work?

LOAD BRNO AS LNK_BRNO,

  BRNO,

    BRENAME,

   RSMENAME,

   DSDENAME

FROM*********************************************(qvd)

WHERE EXISTS (LNK_BRNO,BRNO) AND DSDENAME<>'CLOSED';

[sunny_talwar]

Yup that could be the issue

[aaronnayan]

THANKS GUYS FOR ALL THE HELP

ADAM U SMASHED IT CHEERS PAL

[adamdavi3s]

We're glad to help

Please remember to close the thread by marking the correct (and any helpful) answers