Append Fields Tools

把source表的内容输入到target表里面 每一条source记录都会复制到target里面

Append the fields from a source input to every record in a target input. Each record of the target input will be duplicated for every record in the source input. 

笛卡尔连接 S：3  T：4  最后 3*4=12

The result is a Cartesian Join where all records from both inputs are compared 

比如：

Target  Source Final Output (Target first + Source)

一般来说 Target是大的数据源

Source是小的数据源

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

16*5=80 record

5+3=8 field

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.

默认：当source>16条记录的时候 error就会弹出 停止运行-----这时候可以在configuration里面勾选16条的那个记录

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.