Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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