topic Mapping issue in QlikView https://community.qlik.com/t5/QlikView/Mapping-issue/m-p/192870#M54383 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>CustomerGroup_Map:<BR />MAPPING LOAD<BR /> Description as a,<BR /> KeyValue as b<BR />RESIDENT table;</P><P>LOAD<BR /> CustNum,<BR /> applymap('CustomerGroup_Map', Description) AS CustGroup,<BR />Resident table;</P><P>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.</P><P>Edit: A good practive to load DISTINCT values in the mapping table. Just my 2 cents.</P></BODY></HTML> Mon, 21 Sep 2009 22:51:06 GMT disqr_rm 2009-09-21T22:51:06Z Mapping issue https://community.qlik.com/t5/QlikView/Mapping-issue/m-p/192869#M54382 <HTML><HEAD></HEAD><BODY><P></P><P>CustomerGroup_Map:</P><P>MAPPING LOAD</P><P>Description,</P><P>KeyValue</P><P>RESIDENT table;</P><P>LOAD</P><P>CustNum,</P><DIV>applymap('CustomerGroup_Map', Description) AS CustGroup,</DIV><DIV></DIV><DIV>Resident table;</DIV><DIV></DIV><DIV>My error message says "description field cannot be found" any suggestions?</DIV><DIV><BR />Thanks,</DIV><DIV></DIV><BR /><BR /></BODY></HTML> Mon, 21 Sep 2009 22:29:45 GMT https://community.qlik.com/t5/QlikView/Mapping-issue/m-p/192869#M54382 2009-09-21T22:29:45Z Mapping issue https://community.qlik.com/t5/QlikView/Mapping-issue/m-p/192870#M54383 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>CustomerGroup_Map:<BR />MAPPING LOAD<BR /> Description as a,<BR /> KeyValue as b<BR />RESIDENT table;</P><P>LOAD<BR /> CustNum,<BR /> applymap('CustomerGroup_Map', Description) AS CustGroup,<BR />Resident table;</P><P>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.</P><P>Edit: A good practive to load DISTINCT values in the mapping table. Just my 2 cents.</P></BODY></HTML> Mon, 21 Sep 2009 22:51:06 GMT https://community.qlik.com/t5/QlikView/Mapping-issue/m-p/192870#M54383 disqr_rm 2009-09-21T22:51:06Z