topic Re: How to exclude a record in the script? in QlikView

How to exclude a record in the script?

Anonymous — Wed, 10 May 2017 19:40:25 GMT

Hi guys,

We are experiencing some problem in the database which stopped QV from reloading. We've pick a few records and we'd like to exclude them from the script to try to catch the problem but I keep getting syntax error.

Here is my script. I am trying to exclude OrderNum = 1234567 but it stopped right at SQL select *. Please help.

LOAD
CustNum,
OrderNum,
SalesRepList,
CheckBox06,
Company,
RepRate1
SQL Select *

FROM PUB.OrderHed

where

not

( OrderNum = 1234567);

Re: How to exclude a record in the script?

sunny_talwar — Wed, 10 May 2017 19:43:29 GMT

Have you tried running this outside of QlikView, in Toad?

Select *

FROM PUB.OrderHed
Where not (OrderNum = 1234567);

Re: How to exclude a record in the script?

Anonymous — Wed, 10 May 2017 19:45:39 GMT

Thanks for answering. We don't have Toad. I can only test it in QV...:(

Re: How to exclude a record in the script?

el_aprendiz111 — Wed, 10 May 2017 19:48:14 GMT

where

( OrderNum <> 1234567);

Re: How to exclude a record in the script?

sunny_talwar — Wed, 10 May 2017 19:48:35 GMT

I guess you need to figure out if the SQL syntax is right or not.... try this

LOAD
CustNum,
OrderNum,
SalesRepList,
CheckBox06,
Company,
RepRate1;

Select *

FROM PUB.OrderHed
Where OrderNum NOT IN (1234567);

Re: How to exclude a record in the script?

Anonymous — Wed, 10 May 2017 20:18:40 GMT

did yo find an answer?

I think the correct code is

where

( OrderNum <> '1234567');

Re: How to exclude a record in the script?

Anonymous — Wed, 10 May 2017 20:21:16 GMT

which kind of database do you use: Oracle, MS SQL, MySQL?

Re: How to exclude a record in the script?

Siva_Sankar — Thu, 11 May 2017 01:40:02 GMT

Use the below one..

LOAD

CustNum,

OrderNum,

SalesRepList,

CheckBox06,

Company,

RepRate1;

SQL Select *

FROM PUB.OrderHed

where

OrderNum <> '1234567';