Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
paulyeo11
Valued Contributor II

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

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.

3 Replies
ali_hijazi
Honored Contributor

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

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
Valued Contributor II

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

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
Honored Contributor

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

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

Community Browser