Inputting Data from Files
As data workers, no matter how mature and evolved your actual working environment is, you’ll have to deal with a good number of files and different formats, even when they refer to the same kind of data.
Through the years, I’ve seen a lot of analysts struggling with the same problems, such as vendor files that are not consistent, structure changes through versions of the same file, and so on.
In this chapter, we’ll start defining recipes for those common situations you’ll encounter when reading files using Alteryx Designer.
We’ll read multiple Excel files from a single directory, multiple worksheets from an Excel file, and multiple Excel files having different structures between worksheets. Specifically, we’ll look at the following recipes:
- Reading a worksheet from multiple Excel files all at once
- Reading all worksheets from an Excel file all at once—same schema
- Different schema Excel...