Challenge #118: Think Like a CSE - A not-so-wild-wildcard input!

[alacoume]

My solution:

Spoiler

I have changed the file 4 sheet name et add a sheet range. It works fine.

[bkclaw113]

Spoiler

I have done the batch macro route at least a dozen times so did not bother for this.
I just had the 'client' update the tab name to sheet1.

Another solution would be for Alteryx to fix the dynamic import tool so that it unions after all data is imported so you do not get the schema error when importing multiple sheets.

[StanleyKinnok_Chan]

Here is my solution

[chandler-gjino]

attaching my solution

[aiahwieder]

Tada!

[JarekSkudrzyk]

thank you @SeanAdams for a perfectly concise workflow
my solution based on the same idea below

[geoff_zath]

Spoiler

Spoiler

[SylwiaDragon]

This is my go-to solution for such cases

[tristank]

I had no idea how to approach this and immediately went hunting through Google. I found this amazing resource on how to read in files with different schemas and it worked great!

What I learned from this challenge:

1. Reading in files with different schemas cannot be done with dynamic input.

2. You can make a batch macro without a macro input and just an input tool and macro output.

3. How to append a sheet name to the end of a file path to get the specific sheet.

All great stuff.

Spoiler

[mithily]

Spoiler

Batch macro with schema change