âShow Table of Contents
The Append Fields tool will Append 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.
The Append Fields tool accepts 2 inputs, Target and Source. Ensure the Source side (S input) of the tool contains FEWER records than the Target (T input).
Use the Select grid to choose which fields will come through
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. Choices include:
Error on Appends of more than 16 records (Default ): If more than 16 records are in the Source file (S input) an error will be reported in the Output log and the workflow will stop processing.
Warning on Appends of more than 16 records: If more than 16 records are in the Source file (S input) an Warning will be reported in the Output log and the workflow will continue processing.
Allow all Appends: All records will be appended to all records with no error or warning.
Example: Target (T) input contains: 16 records with 5 data fields; Source (S) input contains 5 records with 3 fields. The output generated from the Append Fields contains 80 records with 8 fields
Click Apply to have the configurations accepted.
For information regarding Input, Output, Annotation and Error Properties, see Tool Properties.