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

iamme012397
8 - Asteroid

I hope this is enough 

 

my rows dont match the number of rows in final output but okay

CKP
10 - Fireball

My solution

 

Spoiler
challenge_45_mysolution.jpg
Treyson
13 - Pulsar
13 - Pulsar

This challenge has been haunting me for several years now. I have gone back 5 or 6 times to attempt it and something has always come up as I work through it. I finally finished it! Results are different because of dates but it works.

Treyson Marks
Managing Partner
DCG Analytics
Sylvana
8 - Asteroid

My solution.

 

jarrod
ACE Emeritus
ACE Emeritus

some obvious updates to the data, but looks like it all parsed correctly.

Spoiler
jarrod_0-1591218148962.png

 

Parul_Kapoor
8 - Asteroid

Solution attached.

cc000072
8 - Asteroid

Here is my solution, there are some gaps downloaded data..

Spoiler
WeeklyChallenge_Ryohei_45.JPG
mattreynolds
9 - Comet

RegEx to the "regscue"!

 

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !

Normster
8 - Asteroid

Glad to see I'm not the only one who had difficulty getting the same results as the solution due to differences in downloaded data.  Nevertheless, I think I got it (Browse tool).

 

Spoiler
Normster_0-1594389004453.png