We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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 #180: Thousand File Challenge

Minanashat
8 - Asteroid

Screenshot 2025-03-15 120519.png

JBevan89
8 - Asteroid

Interesting Challenge.

 

I suppose there are different factor's to whether your workflow pulls the correct values, including what version of Alteryx you have, and whether the source files are not corrupt, amongst other considerations.

Matthias_Albert
8 - Asteroid

Probably the toughest challenge for me so far. The sneaky bit is to just completely ignore the dynamic input tool and build a "better version" yourself with the batch macro. Had to peek into the solutions for the part about selecting the file type via dropdown id in the input tool.

 

Spoiler
macro:
Matthias_Albert_1-1751642624126.png

workflow:
Matthias_Albert_0-1751642599175.png

 

Carolyn
12 - Quasar
12 - Quasar

Solved! I spent forever trying to figure out what was wrong with my macro because I kept only getting a single value out. For some reason, the trick was adding a Select after the macro, and then suddenly all my values appeared...? I don't understand what's up with that, but am glad I got there eventually.

 

Spoiler
2025-07-08 10_52_08-Alteryx Designer x64 - _challenge_180_Carolyn.yxmd.png

 

2025-07-08 10_52_22-Alteryx Designer x64 - Thousand File Input Macro.yxmc.png

 

Carolyn
12 - Quasar
12 - Quasar

... Oops... I was so excited to be finished that I forgot to attach the workflow 😂

Erin
11 - Bolide

I did it! 

Macro:

Spoiler
180macro.png

Workflow:

Spoiler
180.png