Discussion Board for collaboration on QlikView Scripting.
Below is the script working fine :-
ApplyMap('SegmentMap', subfield(trim(kode_reject),' ',1), 'Other') AS DESC_REJECT2
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.
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;
Thank you for your advise , i try to create the script as below :-
add load kode_reject,
But it does not create the DESC_REJECT2 field
you need to assign ADD before load for the mapping load of SegmentMap