0 Replies Latest reply: Nov 18, 2014 1:23 AM by PAUL YEO RSS

    How to make use of partial reload for create one common time line ?

    PAUL YEO

      Hi All

       

      I have below code work fine , i don't to duplicate create dat Year YearMonth for both table , i want to create a common script just for time line , may i know how can i modify ?

       

      LOAD

      *,

      day(date_time)      as [day],

      year(date_time)      as [Year],

      Date(Monthstart([date_time]), 'YY MMM') as YearMonth;

      select * from record_produksi_plc;

       

       

       

       

      LOAD *,

      day(date_time)      as [day],

      year(date_time)      as [Year],

      Date(Monthstart([date_time]), 'YY MMM') as YearMonth,

      Pick(Match(kode_reject, 5, 39), 'reject human error', 'reject machine error') AS DESC_REJECT;

      SQL select * from record_reject_detail_plc;