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 #434: Summing Across Many Rows

braveraj
11 - Bolide
Spoiler
Sum Workflow.pngSum Results.png
ed_hayter
12 - Quasar

Good reminder pivots and unpivots remain a 'pivotal' skill

 

Spoiler
image.png

 

ferg_smith
8 - Asteroid

Lovely little pivoting challenge

ggruccio
ACE Emeritus
ACE Emeritus

I had to round the solution to 2 decimal places as well to get the match!

 

Spoiler
Screenshot 2024-07-22 123423.png
JamesCharnley
13 - Pulsar
Spoiler
 

Nice lines

 

 

HFulghumES
5 - Atom

 

Spoiler
 
 
Screenshot 2024-07-22 at 12.16.51 PM.png

I'm a bit perplexed that the "answer" output still had a null value, but everything else lines up. 

 

sfarnham1
7 - Meteor

Proposed solution

ScottLewis
10 - Fireball

Getting better at the flipping, unless you count not remembering which one is cross tab and which one is transpose.

This one was interesting because the obvious design changes if you think about doing both things rather than doing 1 then 2.

There's also a nice hidden lesson in extensibility. What if there was a new code? A new GEO_ID? Both? Would your process still work? 

 

434Scott.PNG

erike601
7 - Meteor
Spoiler
 

alteryxchallenge434.jpg

SPetrie
13 - Pulsar
Spoiler
snip.PNGsnip.PNG