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

TonyAndriani
9 - Comet

Reposting to my new user ID.

binuacs
21 - Polaris

solution attached

SylwiaDragon
8 - Asteroid

It looks like the page was moved.

I will have to skip this challenge :)

SylwiaDragon_0-1652279519957.png

 

usmanghayoor
8 - Asteroid
Spoiler



usmanghayoor_0-1652958830800.png

 

The Bureau has moved this data but got lucky and got the data from website archive list ! but frankly speaking there was nothing much to do in the challenge after that !

usmanghayoor
8 - Asteroid

Hi this is available if you want to give it a try, got it from the Bureau website archives!

mmontgomery
11 - Bolide
11 - Bolide

Challenge #45

FilipR
11 - Bolide

Solved.

 

Spoiler
FilipR_0-1654797719265.png

 

AliAb
Alteryx Alumni (Retired)

solution attached

Amol_Telore
11 - Bolide

Seems like this URL is not valid anymore..

When I tried to download data from "http://www.bls.gov/web/empsit/compaes.txt" it gave me HTTP code 301 Move Permanently along with new URL.

i.e. "https://www.bls.gov/web/empsit/compaes.txt"

But when I tried this new URL as well it returned 400 Bad Request HTTP Code. 

Does anyone have access to the actual raw data downloaded from above URL?

Albert_Vega
8 - Asteroid

Unfortunately, I'm unable to find the file to download either by the link provided or in the archives. There are posts with the xls file, but that somewhat defeats the purpose. I'd like to try this challenge if a valid url is posted in the future.

 

Albert_Vega_0-1658072208201.png