Discussion Board for collaboration on QlikView Scripting.
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 ?
ApplyMap('MappingTableName', MappingField) AS NewlyMappedField
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')
First you need to load the data in a Mapping Load.
Then once loaded, use the Apply map syntax on the field that exists in both tables:
ApplyMap('MappingTableName', CommonField2) AS NewField