Setting Append Options

Match fields by. Select a method to use when matching fields to append.

• Position. Select to append datasets based on the position of fields in the main data source. When using this method, your data should be sorted to ensure proper appending.
• Name. Select to append datasets based on the name of fields in the input datasets. Also select Match case to enable case sensitivity when matching field names.

Output Field. Lists the source nodes that are connected to the Append node. The first node on the list is the primary input source. You can sort the fields in the display by clicking on the column heading. This sorting does not actually reorder the fields in the dataset.

Include fields from. Select Main dataset only to produce output fields based on the fields in the main dataset. The main dataset is the first input, specified on the Inputs tab. Select All datasets to produce output fields for all fields in all datasets regardless of whether there is a matching field across all input datasets.

Tag records by including source dataset in field. Select to add an additional field to the output file whose values indicate the source dataset for each record. Specify a name in the text field. The default field name is Input.