Transformations

<Transformations> element is useful when the source file need some transformations before the dataset is synced. In the example below, the dataset of source column "net worth" starting with "$" is replaced with " " in the target dataset.
<Transformations>
<!-- Array of <StringReplacement> -->
...
</Transformations>
<Column name="net worth" ordinal="3" dataType="Number"
maxLength="50" isMandatory="false" validateData="true"
trimWhitespace="true" description="">
<Transformations>
<StringReplacement pattern="\$" replacement="" />
</Transformations>
</Column>