topic Mapsubstring or Mapping case sensitive fieldvalues in QlikView

Mapsubstring or Mapping case sensitive fieldvalues

Mon, 26 Jul 2010 16:55:16 GMT

I have two fieldvalues coming from different Sources and they are

Pasteur Opwarmen and Pasteur opwarmen. These values are both same. How can I adjust them.

I tried Mapsubstring like this


M_MappingID:
Mapping
LOAD * INLINE [
 F1, F2
 Pasteur Opwarmen, Pasteur opwarmen
];

Table:
Load....
.....
Mapsubstring('M_MappingID','Pasteur Opwarmen'),
applymap(...)
From
files/...
;

I dont see any change.

Any ideas??

Thanks

sravan

Mapsubstring or Mapping case sensitive fieldvalues

Miguel_Angel_Baeyens — Mon, 26 Jul 2010 17:23:46 GMT

Hello Sravan,

Using

ApplyMap('M_MappingID', OldFieldName) AS NewFieldName

where OldFieldName is the name of the field that stores the old value and NewFieldName is the name you want to use the new changed value in the table should work.

Is this what you are looking for?

Regards

EDIT: If you are working with names, you may use function Capitalize, should all words in that field begin with capital letter, so

Capitalize(FIELD)

where FIELD contains 'aaa bbb' will return 'Aaa Bbb'

Mapsubstring or Mapping case sensitive fieldvalues

Tue, 27 Jul 2010 17:57:51 GMT

Thanks capitalize worked..