topic mappings in QlikView https://community.qlik.com/t5/QlikView/mappings/m-p/228323#M80366 <HTML><HEAD></HEAD><BODY><P>I'd try something like</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">ErrorMatchMap:MAPPING LOAD * INLINE [ RegionIncorrect, RegionCorrect Noth, North Nort, North SOuth, South Soth, South];CorrectRegions: LOAD ApplyMap('ErrorMatchMap', RegionNameField) AS RegionNameField FROM ...</PRE></BLOCKQUOTE><BR /><BR /> <P>Hope this helps!</P></BODY></HTML> Tue, 02 Feb 2010 08:45:18 GMT Miguel_Angel_Baeyens 2010-02-02T08:45:18Z mappings https://community.qlik.com/t5/QlikView/mappings/m-p/228321#M80364 <HTML><HEAD></HEAD><BODY><P>I have an excel sheet with a field called</P><P>Regions and under Regions is a number of names like North South etc. Now some of these are incorrect when the come through example South should be Southwest.</P><P>How can I or can I use mappings to change a field value to another value?</P><P>Only been using this for 3 days so far and so far I have been able to find examples and such but this one has me stumped.</P><P>thanks</P><P></P><P>Mike</P></BODY></HTML> Tue, 02 Feb 2010 00:22:19 GMT https://community.qlik.com/t5/QlikView/mappings/m-p/228321#M80364 2010-02-02T00:22:19Z mappings https://community.qlik.com/t5/QlikView/mappings/m-p/228322#M80365 <HTML><HEAD></HEAD><BODY><P>Hi Thetickisme ,</P><P>Welcome to Qlikview <IMG alt="Yes" src="http://community.qlik.com/emoticons/emotion-21.gif" /></P><P>If i get you correct , its advisable to use inline tables as one of the best possible option.</P><P>Also , there are few functions you can use in script , so that while loading respective mapped values can be taken.</P><P></P><P></P></BODY></HTML> Tue, 02 Feb 2010 07:00:59 GMT https://community.qlik.com/t5/QlikView/mappings/m-p/228322#M80365 2010-02-02T07:00:59Z mappings https://community.qlik.com/t5/QlikView/mappings/m-p/228323#M80366 <HTML><HEAD></HEAD><BODY><P>I'd try something like</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">ErrorMatchMap:MAPPING LOAD * INLINE [ RegionIncorrect, RegionCorrect Noth, North Nort, North SOuth, South Soth, South];CorrectRegions: LOAD ApplyMap('ErrorMatchMap', RegionNameField) AS RegionNameField FROM ...</PRE></BLOCKQUOTE><BR /><BR /> <P>Hope this helps!</P></BODY></HTML> Tue, 02 Feb 2010 08:45:18 GMT https://community.qlik.com/t5/QlikView/mappings/m-p/228323#M80366 Miguel_Angel_Baeyens 2010-02-02T08:45:18Z