topic Re: HELP excluding a certain value from a field in QlikView

HELP excluding a certain value from a field

aaronnayan — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: HELP excluding a certain value from a field

adamdavi3s — Tue, 21 Mar 2017 10:52:44 GMT

This should work?

LOAD *

WHERE DSDENAME<>'CLOSED';

LOAD BRNO AS LNK_BRNO,

BRNO,

BRENAME,

RSMENAME,

DSDENAME

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

WHERE EXISTS (LNK_BRNO,BRNO) ;

Re: HELP excluding a certain value from a field

sunny_talwar — Tue, 21 Mar 2017 10:57:19 GMT

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';

Re: HELP excluding a certain value from a field

adamdavi3s — Tue, 21 Mar 2017 11:02:05 GMT

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';

Re: HELP excluding a certain value from a field

sunny_talwar — Tue, 21 Mar 2017 11:03:14 GMT

Yup that could be the issue

Re: HELP excluding a certain value from a field

aaronnayan — Tue, 21 Mar 2017 11:04:53 GMT

THANKS GUYS FOR ALL THE HELP

ADAM U SMASHED IT CHEERS PAL

Re: HELP excluding a certain value from a field

adamdavi3s — Tue, 21 Mar 2017 11:07:04 GMT

We're glad to help

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