Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi Josh,
Try,
Load ..
From
Excel where AccountNumber > 999 and AccountNumber < 2000;
Hi Josh,
Try,
Load ..
From
Excel where AccountNumber > 999 and AccountNumber < 2000;
load *
from souce where AccountNumber >=1000 and AccountNumber <=1999;