topic Re: How to exclude a value range from loading in script in QlikView

How to exclude a value range from loading in script

omyahamburg — Fri, 22 Jun 2012 08:35:44 GMT

Hello everybody

In my script I load one field with a range of values:

e.g.

Field 1

1398005

1400001

1400002

1400003

1400004

1400004/01

1400005

1400006

1400007

1400008

1400009

1400010

1401009/1

1401009

1474385

2453474

2773319

8447565

9354793

9703607

How can I set in the script, that values 1400001-1401009 will be excluded, but 1400004/01 + 1401009/1 will be loaded together with all other values ?

Thanks for your help.

Re: How to exclude a value range from loading in script

Fri, 22 Jun 2012 08:55:25 GMT

Hi,

Just write sql statement in the script It works

example:

SQL SELECT NAme,Roll

FROM Supriya.dbo.Customer WHERE Roll NOT BETWEEN 9 AND 99 ;

Thanks,

Supriya

Re: How to exclude a value range from loading in script

deepakk — Fri, 22 Jun 2012 09:06:02 GMT

hi,

You can try out the method used in the application.

There might be easier ways but at the moment I can think only of this

Deepak

Re: How to exclude a value range from loading in script

omyahamburg — Fri, 22 Jun 2012 09:07:19 GMT

Hi,

thank you, in my script WHERE [Field 1] NOT BETWEEN... does not work.

[Table2]:

load [Field 1]

Resident Table1;

DROP Table1;

Re: How to exclude a value range from loading in script

omyahamburg — Fri, 22 Jun 2012 09:11:25 GMT

Hi Deepak

That looks great, thanks a lot, I will try it.

Joerg

Re: How to exclude a value range from loading in script

Fri, 22 Jun 2012 09:20:31 GMT

Hi,

Try using

[Field 1]< 1400001 AND [Field 1]> 1400009

Hope this helps.

BR, Neha