Ranges in script

[#1]

Good day,

I have the following script:

LOAD

AccountCode               as  Account,
CustomerSName          as Customer,
NLControlAccount         as [NL Code],
CompanyKey

SQL

SELECT
AccountCode,
CustomerSName,
NLControlAccount,
CompanyKey

I only want to pull info where the NL Control Account is bigger than '20000000000' and smaller that '400000000000'.

This I want all the NL Control Accounts that is between 300000000000 and 39999999999.

Not sure how to write it in the script.

Please advice.

Thank you

*R*

[sujeetsingh]

aFTER LOADING JUST WRITE THE NESTED IFF STATEMENT

=IF(nil>20000000000 AND <=400000000,'RANGE 1;',

IF(----

[sujeetsingh]

sEE THIS Range function

[sujeetsingh]

yOU CAN USE cLASS FUNCTION TOO

class( var,10 ) with var = 23 returns '20<=x<30'

class( var,5,'value' ) with var = 23 returns '20<= value <25'

class( var,10,'x',5 ) with var = 23 returns '15<=x<25'

[CELAMBARASAN]

Try like this

LOAD

AccountCode               as  Account,
CustomerSName          as Customer,
NLControlAccount         as [NL Code],
CompanyKey;

SQL

SELECT
AccountCode,
CustomerSName,
NLControlAccount,
CompanyKey

FROM TAbleNAme Where NLControlAccount between 20000000000 and 400000000000;

[its_anandrjs]

You can also try with

LOAD

AccountCode               as  Account,
CustomerSName          as Customer,
NLControlAccount         as [NL Code],
CompanyKey;

SQL

SELECT
AccountCode,
CustomerSName,
NLControlAccount,
CompanyKey

From Location where NLControlAccount > 20000000000  and NLControlAccount < 400000000000;

And about your requirement write like

From Location where NLControlAccount > 300000000000  and NLControlAccount < 400000000000;