5 Replies Latest reply: May 11, 2014 1:35 PM by Valdi Alkitri RSS

    load table with where two/three fields condition

    Valdi Alkitri

      Guys, i need your help..

      how to write script if i want to make table with where condition:

      example:

       

      table_a:

      LOAD SOURCE1,

           COST_CENTRE,

           DATEGL,

           PERIOD,

           YEARGL,

           MONTHGL,

           PERIOD_REPORT,

           %Admitted,

           AMOUNT,

           MAP_1,

           MAP_2,

           MAP_3,

      FROM

      D:\table_a.QVD

      (qvd)

      WHERE [PERIOD_REPORT='2013007','2013008','2013009','2013010','2013011','2013012','2014001','2014002','2014003','2014004']

             and [COST_CENTRE='S812', 'S813', 'S814', 'S815', 'S818', 'S916', 'S919', 'S920', 'S921', 'S922','S923']

             and [MAP_1='Expense'] and [MAP_2='Management Expense']

             and [MAP_3='Depreciation','Fixed Assets Expenses',]

      store table_a into table_a.qvd (qvd)

       

      but error when i'm reloading thats script. (T_T)

      Please help me ...