Advanced mapping operations

---

The Map in place editor has several advanced operations that allow for complex data transformations.

The following sections discuss the following functionality:

Sort records

Creating an XML field based on a record

Remove multiplies

Conversion of fields to many records in a form of Key-Value pairs - UNPIVOT

Split field to record

Cloning lists

Changing records to multiple

Importing records from a file

Select records conditionally

Fixed-length format field

Delete records conditionally

Parse field in a fixed-length format

Flattening structures

Records validation

Merge records

Mapping to XML (XSD)