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

Laurap1228
11 - Bolide

No a very elegant solution but here it is:

Spoiler
challenge45.PNG
CHarrison
8 - Asteroid

My solution :) 

Greg_Murray
12 - Quasar

Took the long way around, but I got there.

ch12345
7 - Meteor

I think there was an easier way to parse columns, and I had to cheat a bit with the download (used an input tool rather than a download tool to download the data to cache), but I think this works:

kat
12 - Quasar
Spoiler
Challenge #45.PNG
CaraI
Alteryx
Alteryx

 

Spoiler
45 workflow.jpg
OldDogNewTricks
10 - Fireball

Regex and I are buddies now...

 

Spoiler
challenge_45_completedScreen.jpg
danrh
13 - Pulsar
 
danilang
19 - Altair
19 - Altair

Complex!  Good Challenge

 

Spoiler
Solution 45.png

Dan

MarMu
8 - Asteroid

 

Good challenge, pretty comprehensive solution.

Unable include validated result as www.bls.gov has changed/updated dataset. However it looks correct

 

Spoiler
challenge_45_start_file_MarMu.png