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.
Only a very small percentage is successfully mapped, however, the rest are not getting mapped.
Is there something I am missing?
_Map_Stores: MAPPING LOAD DISTINCT Text(MyGUID), MyStore RESIDENT StoreInfo; LOAD *, APPLYMAP('_Map_Stores', MyGUID, 'No Store Match') AS MyStore RESIDENT StoreSummary;
is there something unique about GUIDs and QV that I don't know?
