We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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
18 - Pollux
18 - Pollux

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