Transformation

A transformation is a tool available inside the Bunker web UI, which helps match your original data to InfoSum's Global Schema.

Transformations are flexible and powerful, and can rewrite your original data using a wide range of scripted rules.

When you use a transformation, you can configure a series of changes - such as "remove the first letter" or "change this word into that one" - which your Bunker will apply to each row your original data. For example, you could use this technique to clean up messy data, or to extract a date of birth encoded in a customer number.

You can set up simple transformations using an online wizard. For more complicated tasks, you can write transformation scripts using InfoSum's specialist programming language, the Data Transformation Language (DTL).

See also mapping, a simpler alternative suitable for straightforward tasks.