Specifying Conditions for a Merge

By setting the merge method to Condition, you can specify one or more conditions to be satisfied for the merge to take place.

You can either enter the conditions directly into the Condition field, or build them with the aid of the Expression Builder by clicking the calculator symbol to the right of the field.

Add tags to duplicate field names to avoid merge conflicts If two or more of the datasets to be merged contain the same field names, select this check box to add a different prefix tag to the start of the field column headers. For example, if there are two fields called Name the result of the merge would contain 1_Name and 2_Name. If the tag has been renamed in the data source, the new name is used instead of the numbered prefix tag. If you do not select this check box, and there are duplicate names in the data, a warning is displayed to the right of the check box.