<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.

    <!-- Array of <StringReplacement> -->
<Column name="net worth" ordinal="3" dataType="Number" 
      maxLength="50" isMandatory="false" validateData="true" 
      trimWhitespace="true" description="">
          <StringReplacement pattern="\$" replacement="" />

Last updated