Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
omyahamburg
Creator II
Creator II

How to exclude a value range from loading in script

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.

5 Replies
Not applicable

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

deepakk
Partner - Specialist III
Partner - Specialist III

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

omyahamburg
Creator II
Creator II
Author

Hi,

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

[Table2]:

load [Field 1]

    

Resident Table1;

DROP Table1;

omyahamburg
Creator II
Creator II
Author

Hi Deepak

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

Joerg

Not applicable

Hi,

Try using

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

Hope this helps.

BR, Neha