What type of join does the Append Fields tool perform?

The Append Fields tool in Alteryx performs a Cartesian join, which combines every record from one dataset with every record from another dataset. This type of join creates a Cartesian product, meaning that if you have, for example, 3 rows in the first dataset and 4 rows in the second dataset, the result will be 12 rows (3 multiplied by 4).

Using the Append Fields tool is particularly useful when you want to include all combinations of records from two datasets without any conditions or limitations typically associated with other types of joins, such as matching based on a common key or field. In scenarios where you want to merge fields across all records regardless of their values, this tool efficiently facilitates that process.