You can create a mapping in advanced mode. In advanced mode, the Mapping Designer updates the mapping canvas to include transformations and functions that enable advanced use cases.
To run mappings in advanced mode, enable the read and write capability for advanced mode when you build a connector.