Best way to change values in field

[hopkinsc]

Hi,

I have some values in a field 'Sales Pool'. There have been keying in errors and i wanted a way to change the incorrect vales within Qlikview.

A request has been put in to have the values corrected in the database but this can sometimes take months to get done!

Here is an example of the field..

[Sales Pool]

DIR

LG

CON

OTH

lg

lG

the vales i want changed are the last 2, thses are both supposed to be LG. so at the moment i have to select the 3 values whereas it should just be LG

Can anyone help?

[lironbaram]

if the only thing you need is to change all data

to upper case , then you can do it in the load script of qlikview

by using : UPPER([Sales Pool]) AS Sales Pool

[#3]

try using the following script:

[Text Substitutions]:
MAPPING LOAD * INLINE [
From, To
lg, LG
lG, LG

     ];

LOAD
...

,mapsubstring('Text Substitutions',YOURFIELD) as YOURFIELD
...
from YOURTABLE;