<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 "quot; 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="" />
Copy link