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

mpennington
11 - Bolide

Solution attached.  

 

Spoiler
MP45.png
SamDesk
11 - Bolide
Spoiler
SamDesk_0-1584619033806.png

 

Sam

aazimh
8 - Asteroid

This was quite the ride - almost punched something when I realized the columns weren't tab-separated 🙂 good fun though!

atcodedog05
22 - Nova
22 - Nova

On a spree to binge complete weekly challenges

 

Used Cache and Run option to speed up data download and execution 🙂

 

Spoiler
This is my solution

atcodedog05_0-1585313245006.png

 

kaianderson
8 - Asteroid

Here's my solution in terms of formatting. I don't think the output is actually possible to get to, given the difference in years of data provided...

aheikes
8 - Asteroid
Spoiler
Challenge45.JPG
dpencheva
8 - Asteroid

Here is my solution. Very interesting task!

AndrewS
11 - Bolide

#45

steven4320555
8 - Asteroid

The recent practices helped.

 

Spoiler

steven4320555_1-1587068508996.png

I also practiced adding annotations.


steven4320555_0-1587068972680.png

Note the data does update over time. I was dealing with 2010-2019 data. [data earlier than 2010 may need to be dug elsewhere.]



A bonus for me: Happy to see the data lineage information from the selection tool. 
steven4320555_0-1587068248122.png
 
 
 

 

 

 

 

 

Junya_Wang
8 - Asteroid
Spoiler
Junya_Wang_0-1588772460270.png

 

quite a few tools being used