4 Replies Latest reply: Aug 24, 2017 8:27 AM by Sunny Talwar RSS

    Optomized load not working

    yusuuf rawat

      Why is this not an optimzed load , if i comment out the the where statement it is , if i add it to load on year 2014 ,2015, 2016 , 2017 , it loads those years but not in an opmized load ?

       

       

      Temp_dates:
      LOAD * Inline [
      FIN_JAAR
      2014
      2015
      2016
      2017
      ]
      ;

      "MAANDEINDE BALANSE":
      load

         [FIN JAAR]
       
      from $(DATA_QVD)maandeindebalanse.qvd (qvd) where Exists(FIN_JAAR,[FIN JAAR]);


      DROP Table Temp_dates;
      EXIT Script;