Different schema Excel worksheets all at once
The most complicated situation is when we need to consolidate Excel files that have different schemas.
As we saw in recipe #2, if the schema of the worksheets is not the same, we get a warning from Alteryx Designer, and the contents of that worksheet are not read:
Figure 1.18: Warning for unmatching schema
In this recipe, we’ll create a batch macro to read each worksheet within an Excel file, even when they have a different schema.
Getting ready
We prepared a test set for you to follow along with this recipe, available at https://github.com/PacktPublishing/Alteryx-Designer-Cookbook/tree/main/ch1/Recipe3.
If you decided to use your data to try this recipe, make sure that your files have different schemas (with some fields in common so that you can see the effects of different configurations).
Make sure that under the Options→User Settings→Edit User Settings→Macros tab...
