Reading all worksheets from an Excel file at once – same schema

Another common situation is to have all your data spread across multiple worksheets. So, we need to read them all and put them together:

Figure 1.9: Our data file worksheets

As always, we’ll make it simple for you, since Alteryx Designer allows us to.

Getting ready

If you want to follow along with this recipe, please download our test set here:

https://github.com/PacktPublishing/Alteryx-Designer-Cookbook/tree/main/ch1/Recipe2

Here, you’ll find an Excel file with yearly data spread across multiple worksheets, and by applying this recipe, we’ll be reading them all at once.

If you want to try this recipe with your data, make sure of the following:

• All your worksheets have the same schema (field/column names and data types).
• You have a list of worksheets to import (we’ll get this directly when first accessing the file using a helpful...