Alteryx for Beginners - Case Study - 5

The video tutorial explains how to append multiple Excel files and sheets from a zip folder using Alteryx. It begins with an introduction to zip files and a case study involving a zip file named CS5. The tutorial then demonstrates how to import data into Alteryx, select specific files, and append sheets. Finally, it shows how to run the workflow and view the results, including how to identify which data comes from which file.

What is the primary focus of the first section in the video?

• Creating Excel sheets

• Using Alteryx for data analysis

• Appending Excel files from a zip folder

• How to create a zip folder

Which tool is used to import and append Excel files from a zip folder?

• Tableau

• Google Sheets

• Microsoft Excel

• Alteryx

What format should be selected in Alteryx to import files from a zip folder?

• TXT format

• CSV format

• ZIP format

• PDF format

How can you verify which data comes from which file in Alteryx?

• By using a separate software

• By opening each file manually

• By selecting the file name option

• By checking the file size

What is the total number of records displayed after appending all files and sheets?

• 150 records

• 104.5 records

• 200 records

• 100 records