Load data if account number is within range of values

[Anonymous]

Hi all,

I'm trying to load the following excel:

AccountNumber | Balance

1000                   |$10

2001                   |$10

1002                   |$10

3000                   |$10

1099                   |$10

and I would like to load only the accounts that fall between 1000 and 1999.

Is there a way I can put an IF statement in the load?

Thank you!

[tamilarasu · Accepted solution]

Hi Josh,

Try,

Load ..

From

Excel where AccountNumber > 999 and AccountNumber < 2000;

[OmarBenSalem]

load *

from souce where AccountNumber >=1000 and AccountNumber <=1999;