Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Contributor II

ApplyMap on Resident Load

Hello, I'm having some difficulty implementing the ApplyMap function to a Resident table.  My script is noted below.  The Temp table becomes the mapping load table.  I then try to use that against a resident table.  But QlikView gives me the error message below the script saying the Field that is in my Mapping Load table is not found.  Any help would be appreciated.

Temp:
Load
POL_N & LOB as PRIOR_CARRIER_KEY,
PRIOR_CARRIER
From C:\QlikView\Daily Quote\v12\PriorCarrier.qvd (qvd);

Concatenate(Temp)
load
POL_N & 'Valuables' as PRIOR_CARRIER_KEY,
PRIOR_CARRIER
From C:\QlikView\Daily Quote\v12\PriorCarrier.qvd (qvd)
where LOB='Home';

PriorCarrier:
Mapping Load
PRIOR_CARRIER_KEY,
PRIOR_CARRIER
Resident Temp;

Load *,
APPLYMAP('PriorCarrier', PRIOR_CARRIER,'Not Available') As PRIOR_CARRIER
Resident [CombinedQuotes];
drop table Temp;
 

1 Solution

Accepted Solutions
Highlighted
Valued Contributor

Re: ApplyMap on Resident Load

if you are trying to add the field PRIOR_CARRIER to the table then

Load *,
APPLYMAP('PriorCarrier',PRIOR_CARRIER_KEY ,'Not Available') As PRIOR_CARRIER
Resident [CombinedQuotes];
drop table Temp;


And PRIOR_CARRIER_KEY should exist in the table [CombinedQuotes]

View solution in original post

6 Replies
Highlighted

Re: ApplyMap on Resident Load

Does CombinedQuotes has a field called PRIOR_CARRIER?

Highlighted
Valued Contributor

Re: ApplyMap on Resident Load

Load *,
APPLYMAP('PriorCarrier', PRIOR_CARRIER,'Not Available') As PRIOR_CARRIER
Resident [CombinedQuotes];
Does the table [CombinedQuotes] has the field PRIOR_CARRIER ???

Highlighted
Contributor II

Re: ApplyMap on Resident Load

No, I am trying to add that field to CombinedQuotes from the Mapping Table.  Do I need to add an empty PRIOR_CARRIER field when loading CombinedQuotes?

Highlighted
Valued Contributor

Re: ApplyMap on Resident Load

you should give the key value which exists in both the tables as below

Load *,
APPLYMAP('PriorCarrier', KEY,'Not Available') As PRIOR_CARRIER
Resident [CombinedQuotes];
drop table Temp;

Highlighted
Valued Contributor

Re: ApplyMap on Resident Load

if you are trying to add the field PRIOR_CARRIER to the table then

Load *,
APPLYMAP('PriorCarrier',PRIOR_CARRIER_KEY ,'Not Available') As PRIOR_CARRIER
Resident [CombinedQuotes];
drop table Temp;


And PRIOR_CARRIER_KEY should exist in the table [CombinedQuotes]

View solution in original post

Highlighted

Re: ApplyMap on Resident Load

Which field in CombinedQuotes matches with the PRIOR_CARRIER within the Mapping Table? Use this name here:

LOAD *,
APPLYMAP('PriorCarrier', FieldName,'Not Available') As PRIOR_CARRIER
Resident [CombinedQuotes];
DROP Table Temp;

Replace FieldName with the field that I mentioned above....