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

    Conditional Load

    Joseph 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;