Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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 #45: Parsing Bureau of Labor Data

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
Maskell_Rascal_0-1619648561305.png

 

Cheers!

Phil

JasonHu
8 - Asteroid
Spoiler
workflow.png

Here is my submission; the data is newer than the original but with the same data structure.

CandiceDB
Alteryx Alumni (Retired)

My solution:

 

Spoiler
CandiceDB_0-1624479567806.png

 

Ajjay
8 - Asteroid
Spoiler
Ajjay_0-1624541540603.png

 

ExploreMore
8 - Asteroid

The current website that you download from seems to have a different data set than the one in the provided solution. It appears it has been updated over the last five years. So my formatting matches but I have 300 more records than the provided solution.

 

 

Spoiler
Screenshot 2021-07-25 173222.png
carmenrapariz
8 - Asteroid
Spoiler
Challenge 45.PNG
FredNajjar
9 - Comet

My results didn't perfectly match the solution provided, as the data has been refreshed to 2020-21. However, this challenge probably took over an hour to resolve, but totally worth the time! 

Spoiler
image.pngFredNajjar_0-1627869231379.png

 

carmenrapariz
8 - Asteroid
Spoiler
Challenge 45.PNG
MichaelPilotFreight
8 - Asteroid

Check out my solution!

Jotigautam
10 - Fireball
Spoiler
Jotigautam_0-1629458189515.png