Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! 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 #180: Thousand File Challenge

SmitaLohande
9 - Comet

My Solution!!

mgaronson
11 - Bolide

mgaronson_0-1678140921085.png

Macro

mgaronson_1-1678140954478.png

Big thanks to EMEA's Filip R at JLL for your explanation.

François_Rs
8 - Asteroid
Spoiler
Franois_Rs_0-1680093830907.png

 

Franois_Rs_1-1680093867782.png

 

alex-green
8 - Asteroid

      

HirokiT
6 - Meteoroid

dynamic input batch macrodynamic input batch macro

good challenge😀

alacoume
9 - Comet

Interesting !

Spoiler
Challenge_180.jpg
chandler-gjino
Alteryx
Alteryx

attaching my solution

ed_hayter
12 - Quasar
Spoiler
Conceptually not too difficult. used the information in the post about file formats as a lookup. Had a few issues with running my batch macro. I think because I lacked a tool following it, it was only running for the initial record to save disk space. Either way when I put tools to follow it (browse then the tools to sum the value fields) it took a while to run but seemingly calculated correctly.

Challenge 180 WF Image.png
gawa
16 - Nebula
16 - Nebula

Done

LorenzNacilla
8 - Asteroid

Was getting one row only after the macro/getting the ended on a downstream tool message. Came across this message for the first time and found it's resolved by putting a browse after it so good to know this!

 

Workflow:

Spoiler
Challenge 180 Flow Solution.png

Macro: 

Spoiler
Challenge 180 Macro Solution.png