Data Transformations

Ziggy has a very useful Data Mapping and Transformation Block that lets non-technical users set up mappings.

Take a look at the following Google Sheet.

This provides a very simple way of handling simple mappings like Mr.-> 1'.

However, you can also supply expressions like $='Dame' or $='Sir'-> 9.

Mapper Block

Ziggy's Mapper Block can then be used to reference this Google Sheet and perform the mapping.