Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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

Natasha
9 - Comet

Used generate rows and regex but in a slightly different order. Also the data is updated to contain 2016 vs 2015 data

Spoiler
Screen Shot 2017-10-29 at 22.07.07.png
JoshKushner
12 - Quasar

Thought it was going to be impossible, but it was actually not too bad!

samN
10 - Fireball

Got a few more rows than the solution file but i think its just updated. Fun little parsing challenge

ggruccio
ACE Emeritus
ACE Emeritus

Fairly challenging!  My data was from 2007 to 2016 also...great parsing exercise.

PhilipMannering
16 - Nebula
16 - Nebula

Regex to the rescue. I feel like I used fewer tools than most sooooooo..... go me.

 

Spoiler
Regex heavyRegex heavy
LandonG
8 - Asteroid

Solution attached.

jasperlch
12 - Quasar

Solution attached.

msicak
8 - Asteroid

the good old multi-row tool. And to think I did not understand/get its use the first time I came across it! 

 

Spoiler
challenge45.png
dominiklz
8 - Asteroid
Spoiler
Capture.PNG

that was quite something, messy data is messy, but cleaning it feels so rewarding :-)

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed