Alteryx for Beginners - Append Fields Tool

The video tutorial explains the concept of Cartesian join using the append fields tool in Alteryx. It starts with an example in Excel, demonstrating how to multiply years and months to create a Cartesian join. The tutorial then transitions to Alteryx, showing how to set up and execute the join using name ranges and the append fields tool. The process results in a Cartesian join, producing a dataset with combined records from two separate datasets.

What does the 'append fields' tool in Alteryx actually perform?

• A subtraction of records

• A division of records

• A Cartesian join

• A simple append of records

In the example provided, how many total records are generated from the Cartesian join of years and months?

• 48 records

• 12 records

• 24 records

• 36 records

What is the first step in preparing data in Excel for use in Alteryx?

• Closing the file

• Selecting the data

• Naming the ranges

• Saving the file

Which Alteryx tool is used to perform a Cartesian join?

• Append fields tool

• Sort tool

• Join tool

• Filter tool

How many records are expected after performing the Cartesian join in Alteryx?

• 12 records

• 48 records

• 4 records

• 24 records