Partial reload create new table , any way how to aviod create new table ?

[paulyeo11]

Hi All

Below is the script working fine :-

temp1:

load  kode_reject,

ApplyMap('SegmentMap', subfield(trim(kode_reject),' ',1), 'Other') AS DESC_REJECT2

resident record_reject_detail_plc;

My issue is after partial reload , it create extra table temp1. may i know how to modify the script , so that  the DESC_REJECT2 field will merge into Table = record_reject_detail_plc

As after recode create new table , it will make table view messy.

[ali_hijazi]

you need first to add an ADD before the load so that this table is loaded in partial reload

to avoid re-creation of the table use the following:

if isPartialReload() then

     drop table temp1;

temp1:

add load.....

end if

[paulyeo11]

Hi Sir

Thank you for your advise , i try to create the script as below :-

if isPartialReload() then

     drop table temp1;

temp1:

add load kode_reject,

ApplyMap('SegmentMap', subfield(trim(kode_reject),' ',1), 'Other') AS DESC_REJECT2

resident record_reject_detail_plc;

end if

But it does not create the DESC_REJECT2 field

PAul

[ali_hijazi]

you need to assign ADD before load for the mapping load of SegmentMap