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>