mappings

[#1]

I have an excel sheet with a field called

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.

How can I or can I use mappings to change a field value to another value?

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.

thanks

Mike

[#2]

Hi Thetickisme ,

Welcome to Qlikview

If i get you correct , its advisable to use inline tables as one of the best possible option.

Also , there are few functions you can use in script , so that while loading respective mapped values can be taken.

[Miguel_Angel_Baeyens]

I'd try something like

ErrorMatchMap:MAPPING LOAD * INLINE [ RegionIncorrect, RegionCorrect Noth, North Nort, North SOuth, South Soth, South];CorrectRegions: LOAD ApplyMap('ErrorMatchMap', RegionNameField) AS RegionNameField FROM ...

Hope this helps!