Append

Add columns from one table to another (cross-join, cartesian join, etc.)

Combine data sets by appending observations together. Helpful for transferring important columns from one data set to another.

Be mindful of the Append. The number of rows in your data set can easily grow exponentially when using the Append Action. The number of rows after the Append Action equals the multiplication of rows from the two data sets you send into the Append Action. So if you have two datasets with 100 rows that you want to append, you will end up with 10.000 rows (100*100=10.000).