Alteryx Advanced - Exercise 1

This video tutorial guides users through a data processing workflow using CSV files and regex for data cleaning. It involves saving outputs to a Calgary database, creating fields, and calculating running totals. The tutorial covers setting up workflows, configuring regex, and managing data outputs, culminating in the creation of indexes for efficient data management.

What is the purpose of using regex in the initial workflow setup?

• To clean the nationality column

• To format the CSV file

• To calculate the running total

• To create a new field

How is the data grouped in the second part of the workflow?

• By dividing into four equal groups

• By using a regex tool

• By creating a new field

• By calculating the running total

What tool is used to calculate the running total in the workflow?

• Regex tool

• Running total tool

• Tile tool

• Auto field tool

What is the final step in the workflow process?

• Creating a new field

• Saving the output to a CSV file

• Cleaning the nationality column

• Adding new indexes to the Calgary database

Which indexes are added to the Calgary database in the final step?

• Input Data, Output Data, and Loader

• Regex, Auto Field, and Tile

• Nationality, Score, and Group

• Tile NUM, Tile Sequence, and Run Total