Alteryx Advanced - Exercise 2

The video tutorial demonstrates how to import an SQL database into Altrix, join tables, and remove excess fields. It guides users through creating data streams to calculate the average number of users per year and export questions from 2019 to an Excel file. The tutorial also covers filtering, sorting, and removing duplicates to finalize the data output.

What is the first step in using SQL data in Altrix?

• Exporting the data to a CSV file

• Importing the SQL database

• Creating a new Altrix workflow

• Connecting to a cloud database

Which tool is used to join tables in the Altrix workflow?

• Select INDB tool

• Summarize INDB tool

• Join INDB tool

• Filter INDB tool

What type of join is used to ensure all matched records are included?

• Left join

• Inner join

• Right join

• Outer join

How do you calculate the average number of users that answer each year?

• Using a Filter INDB tool

• Using a Summarize INDB tool

• Using a Join INDB tool

• Using a Select INDB tool

What is the purpose of the Browse in DB tool in this workflow?

• To filter out unnecessary data

• To display the grouped data

• To remove duplicate fields

• To join multiple tables

Which tool is used to ensure unique questions in the 2019 data stream?

• Filter INDB tool

• Unique tool

• Summarize NDB tool

• Select INDB tool

What is the final step to save the 2019 questions to an Excel file?

• Apply a basic filter

• Use the Output Data tool

• Run the workflow

• Use the Filter INDB tool