2 Replies Latest reply: Dec 20, 2017 11:42 AM by omar bensalem RSS

    Load data if account number is within range of values

    josh goh

      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!