topic Re: Normalising values in QlikView

Normalising values

Mon, 23 Mar 2015 13:09:16 GMT

Hi guys

I have a field called 'Distributor'. I need to roll up the following values within that field so that i.e. 'Gerrys Curtains Ltd', 'Gerrys Curtains Group', 'Gerrys Curtains GMBH' and 'Gerrys Curtains Plc' all roll up into 'Gerrys Curtains Plc'.

Thanks

Sid.

Re: Normalising values

prieper — Mon, 23 Mar 2015 14:16:04 GMT

Have you tried with the MAPPING-function?

mapDistributor:

MAPPING LOAD * INLINE [read, show

Gerrys Curtains Ltd,Gerrys Curtains Plc

Gerrys Curtains Group,Gerrys Curtains Plc

Gerrys Curtains GMBH,Gerrys Curtains Plc

Gerrys Curtains Plc,Gerrys Curtains Plc];

MAP Distributor USING mapDistributor;

Table might be created in Excel or the like as well ....

HTH Peter

Re: Normalising values

maxgro — Mon, 23 Mar 2015 21:18:53 GMT

load

Distributor,

pick(wildmatch(Distributor, 'Gerrys Curtains*', '*'), 'Gerrys Curtains Plc', Distributor) as NewDisstributor;

.......

from

......