4 Replies Latest reply: Aug 8, 2017 9:29 AM by Joe Bajo RSS

    Conditional Load

    Joe Bajo

      I am trying to do a conditional load based upon a date in the data. I am trying to use a preceding load statement, but get the error "field not found". I think there is a problem with the variable I set:


      Load ...

           Date(OrderDate) as OrderDate



      let vRefDate = Year(Max(OrderDate));


      Load ...


      WHERE Year(OrderDate) < vRefDate;