Description
When no field mapping is specified, Append Data will append fields based on matching name and type.
Solution
Default field mapping will only append fields with the same name and type.
Use the Append Fields parameter to append fields with the same type but different name.
Use the Append Expressions parameter to append values calculated from Arcade expressions.