We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

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

alacoume
8 - Asteroid

My solution:

 

Spoiler

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

Challenge118.jpg

 

bkclaw113
9 - Comet
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
8 - Asteroid

Here is my solution

chandler-gjino
Alteryx
Alteryx

attaching my solution

aiahwieder
8 - Asteroid

Tada!

JarekSkudrzyk
11 - Bolide

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

geoff_zath
Alteryx
Alteryx
Spoiler

geoff_zath_0-1686949621408.png

Spoiler

geoff_zath_1-1686949638252.png

 

SylwiaDragon
8 - Asteroid

This is my go-to solution for such cases

tristank
10 - Fireball

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
Screenshot 2023-07-28 105921.png

 

mithily
8 - Asteroid
Spoiler
Batch macro with schema change