Mapping issue

[#1]

CustomerGroup_Map:

MAPPING LOAD

Description,

KeyValue

RESIDENT table;

LOAD

CustNum,

applymap('CustomerGroup_Map', Description) AS CustGroup,

Resident table;

My error message says "description field cannot be found" any suggestions?

Thanks,

[disqr_rm · Accepted solution]

Try:

CustomerGroup_Map:
MAPPING LOAD
Description as a,
KeyValue as b
RESIDENT table;

LOAD
CustNum,
applymap('CustomerGroup_Map', Description) AS CustGroup,
Resident table;

If you have field names same as in original table, qlikview will not create a new table (CustomerGroup). Just rename the fields as above and you will be fine.

Edit: A good practive to load DISTINCT values in the mapping table. Just my 2 cents.