Append Fields Tool

The Append Fields tool appends the fields of one small input (Source) to every record of another larger input (Target). The result is a Cartesian Join where all records from both inputs are compared.

Connect inputs

The Append Fields tool accepts two inputs:

T anchor: Target. The larger data stream that records are appended to.

S anchor: Source. The smaller data stream the provides the records that are added to the Target stream.

Target (T) input contains 16 records with 5 data fields; Source (S) contains 5 records with 3 fields. The output generated from the Append Fields contains 80 records with 8 fields

Configure the tool

Use the table to modify the incoming data stream. Each row in the table represents a column in the data.

Warn/Error on Too Many Records Being Generated: Since the Append Fields tool is performing a Cartesian join, the user can unintentionally produce an excessive amount of records. The user can configure warnings or errors to be reported to ensure too many records are not produced.

  • Allow All Appends: All records will be appended to all records with no error or warning.
  • Warn on appends of more than 16 Records: If more than 16 records are in the Source file (S input) a warning is reported and the workflow continues processing.
  • Error on appends of more than 16 Records: If more than 16 records are in the Source file (S input) an error is reported and the workflow stops processing.