Append Table Transformation

The Append Table transformation lets you append a table with another table similar to SQL based Union and Union ALL operators. This generally works best for tables with the same structure and data types.

Note: You cannot include columns with different data types as part of the union condition.