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

[paulyeo11]

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;