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

Flo_P
9 - Comet
Spoiler
Was expecting worse!
Flo_P_0-1674831663200.png

 

kristiadiuisan
8 - Asteroid

Provided link does not seem to be working anymore. Hence, I used other external data source

Spoiler
Alteryx_challenge_45_KU.png
CeliaC_Silje
8 - Asteroid

Used the source file shared by other users as the URL does not work anymore.

Spoiler
CeliaC_Silje_0-1678289004322.png
mhgarcia
8 - Asteroid

my solution attached

Spoiler
Capture.PNG

 

bkclaw113
9 - Comet

Never used the wayback machine before, but certainly came in handy to find this file that no longer exists.

Spoiler
bkclaw113_0-1679406114544.png

 

Hammad_Rashid
11 - Bolide

WeeklyChallenge45.JPG

Spurs
8 - Asteroid
Spoiler
Spurs_0-1681822813132.png

 

chandler-gjino
Alteryx
Alteryx

Attaching my solution

mgaronson
11 - Bolide
Spoiler
mgaronson_0-1685649557088.png

Had to add an extra piece as 2015 numeric monthly data contained letters. Text manipulation is tedious work. This was a good text manipulation challenge.

lucaskro
8 - Asteroid
Spoiler
lucaskro_0-1685958024565.png