topic Loop and replace value using mapping load? in QlikView

Loop and replace value using mapping load?

Vidit — Wed, 06 Jul 2016 14:52:11 GMT

Hi,

I want to replace a value in a particular column in around 100 qvd files, using apply map. How will be the Script

Basically its a simple task like find all occurance of dept a11 and replace it by a12 in all qvds ?

Thanks

Wed, 06 Jul 2016 15:02:05 GMT

ApplyMap('MappingTableName', MappingField) AS NewlyMappedField

vinieme12 — Wed, 06 Jul 2016 15:06:12 GMT

Place your Applymap code in the load statement and STORE table into before Next QVFILE Statement

This is assuming all you files are in a same folder. or see this post loop through to load all files from a folder and its subfolders?

FOR EACH QVFILE in filelist('fullpathhere\*.QVD')

load *

From $(QVFILE)

(QVD);

Next QVFILE;

ciaran_mcgowan — Wed, 06 Jul 2016 15:08:03 GMT

Hi Vidit,

First you need to load the data in a Mapping Load.

MappingTableName:

Mapping LOAD

CommonField1,

NewField

FROM FileName*.QVD;

Then once loaded, use the Apply map syntax on the field that exists in both tables:

ApplyMap('MappingTableName', CommonField2) AS NewField