Documentation

Value Mapping Transformer

This transformer transforms values to new values. In contrast to Field Mapping , this transformer alters the values of the returned metadata. This is for instance reasonable, when you like to harmonize a heterogeneous wording for item types.

In the example below, we transform file suffixes to a human readable wording.

image-20240811-161441.png

Configuration

  1. Aggregation value mapping as JSON: This is a JSON which defines how to map the values.

    1. The format is a mappings = Map<String,Map<String,String>>.
      Mappings is the root node. The first map determines a field name. The second map determines how exact value matches should be transformed.

    2. If the field is multi-valued, then the mapping is applied to each item of this list.

    3. Please note that mapped values will be replaced and not be kept.

{
   "mappings":{
      "itemType":{
         "mapping":{
            "wbk":"Word document",
            "xlt":"Excel document",
            "spkkg":"Solution",
            "bin":"Binary document",
            "csv":"Excel document",
            "midi":"Audio document",
            "exe":"Executable program",
            "bat":"Batch document",
            "mov":"Video document",
            "tmp":"Temporary data document",
            "ppam":"PowerPoint document",
            "xlam":"Excel document",
            "docm":"Word document",
            "jar":"Java document",
            "wks":"Microsoft Works document",
            "zip":"Compressed document",
            "cda":"Audio document",
            "rar":"Compressed document",
            "mpg":"Video document",
            "vsdx":"Visio document",
            "png":"Image",
            "eps":"EPS document",
            "vsdm":"Visio document",
            "vstx":"Visio document",
            "doc":"Word document",
            "accdb":"Access database",
            "aif":"Audio document",
            "xltx":"Excel document",
            "aac":"Audio document",
            "vsd":"Visio document",
            "accde":"Access database",
            "dot":"Word document",
            "mid":"Audio document",
            "accdr":"Access database",
            "wma":"Audio document",
            "pptm":"PowerPoint document",
            "wmd":"Video document",
            "ppsx":"PowerPoint document",
            "accdt":"Access database",
            "pot":"PowerPoint document",
            "xltm":"Excel document",
            "vst":"Visio document",
            "vss":"Visio document",
            "jpeg":"Image",
            "wms":"Windows Media skins document",
            "dotx":"Word document",
            "wmv":"Video document",
            "xlsx":"Excel document",
            "rtf":"Word document",
            "wmz":"Windows Media skins document",
            "ppsm":"PowerPoint document",
            "docx":"Word document",
            "flv":"Video document",
            "txt":"Text document",
            "pps":"PowerPoint document",
            "ppt":"PowerPoint document",
            "xlsm":"Excel document",
            "xps":"XML document",
            "wp5":"WordPerfect document",
            "dif":"Spreadsheet document",
            "msi":"Installer document",
            "swf":"Shockwave Flash document",
            "bmp":"Image",
            "iso":"Disc image",
            "potm":"PowerPoint document",
            "tif":"Image",
            "aspx":"Web page",
            "sldm":"PowerPoint document",
            "sldx":"PowerPoint document",
            "html":"Web page",
            "mdb":"Microsoft access database",
            "wpd":"WordPerfect document",
            "adt":"Audio document",
            "pptx":"PowerPoint document",
            "mpeg":"Video document",
            "mui":"Multilingual User Interface document",
            "psd":"Adobe Photoshop document",
            "vstm":"Visio document",
            "tiff":"Image",
            "aiff":"Audio document",
            "cab":"Archive",
            "eml":"Email document",
            "gif":"Image",
            "aifc":"Audio document",
            "vob":"Video document",
            "sys":"Sys document",
            "directory":"Directory",
            "adts":"Audio document",
            "pst":"Outlook data store",
            "avi":"Video document",
            "m4a":"Audio document",
            "htm":"Web page",
            "jpg":"Image",
            "vssm":"Visio document",
            "dll":"DLL document",
            "ini":"Configuration file",
            "xla":"Excel document",
            "wav":"Audio document",
            "mp4":"Video document",
            "mp3":"Audio document",
            "pdf":"PDF document",
            "potx":"PowerPoint document",
            "xlm":"Excel document",
            "xll":"Excel document",
            "pub":"Microsoft Publisher document",
            "xls":"Excel document"
         }
      }
   }
}