Alteryx for Beginners - Appending All Comma Separated Value (CSV) files

The video tutorial explains how to manage and append multiple CSV files using Lotrix. It starts with an introduction to the structure of CSV files, followed by a demonstration of appending these files into one using Lotrix. The tutorial also covers the use of wildcards in SQL for file selection and concludes with automating the process to update records when new files are added.

What is the common pattern observed in the file names within the folder?

• They all end with the year 2020.

• They all start with the year 2020.

• They all contain the word 'sales'.

• They all have the same file size.

How many records are there in each CSV file?

• 15 records

• 5 records

• 10 records

• 20 records

What tool is used to append the CSV files into one?

• Excel

• Python

• Lotrix

• SQL

What wildcard character is used to select all files ending with 2020?

• *

• &

• ?

• #

What happens when a new file is added to the folder?

• The total record count increases.

• The total record count decreases.

• The total record count is reset to zero.

• The total record count remains the same.