topic Mapping table does not work in v9.0 with GUIDs in QlikView https://community.qlik.com/t5/QlikView/Mapping-table-does-not-work-in-v9-0-with-GUIDs/m-p/183598#M48795 <HTML><HEAD></HEAD><BODY><P>Here is my code below that is used to create a Mapping Table, for some reason when I use it in APPLYMAP(), the value that I am trying to map, although of same Length which I tested using the LEN() function, does not find all the matches although there is a one-one mapping.</P><P>Only a very small percentage is successfully mapped, however, the rest are not getting mapped.</P><P>Is there something I am missing?</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">_Map_Stores:<BR />MAPPING LOAD DISTINCT Text(MyGUID), MyStore RESIDENT StoreInfo;<BR />LOAD *, APPLYMAP('_Map_Stores', MyGUID, 'No Store Match') AS MyStore<BR />RESIDENT StoreSummary;</PRE><BR /><BR /> <P></P><P>is there something unique about GUIDs and QV that I don't know?</P></BODY></HTML> Fri, 11 Dec 2009 10:58:34 GMT avastani 2009-12-11T10:58:34Z Mapping table does not work in v9.0 with GUIDs https://community.qlik.com/t5/QlikView/Mapping-table-does-not-work-in-v9-0-with-GUIDs/m-p/183598#M48795 <HTML><HEAD></HEAD><BODY><P>Here is my code below that is used to create a Mapping Table, for some reason when I use it in APPLYMAP(), the value that I am trying to map, although of same Length which I tested using the LEN() function, does not find all the matches although there is a one-one mapping.</P><P>Only a very small percentage is successfully mapped, however, the rest are not getting mapped.</P><P>Is there something I am missing?</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">_Map_Stores:<BR />MAPPING LOAD DISTINCT Text(MyGUID), MyStore RESIDENT StoreInfo;<BR />LOAD *, APPLYMAP('_Map_Stores', MyGUID, 'No Store Match') AS MyStore<BR />RESIDENT StoreSummary;</PRE><BR /><BR /> <P></P><P>is there something unique about GUIDs and QV that I don't know?</P></BODY></HTML> Fri, 11 Dec 2009 10:58:34 GMT https://community.qlik.com/t5/QlikView/Mapping-table-does-not-work-in-v9-0-with-GUIDs/m-p/183598#M48795 avastani 2009-12-11T10:58:34Z