Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #45: Parsing Bureau of Labor Data

Highlighted
Alteryx
Alteryx
 
Highlighted
8 - Asteroid

Hi All,

 

Please find my Result below.

 

Spoiler
Download the Data, Text to Columns to make Rows, Trim Useless records, Strip Year and Month Titles for Later Use, Use Multirow to catch Sections and Sub Sections. Join the Titles back based on these. Text to column to get the Values seperated by Month, Join the Month Titles back in, Drop the original data with Select.

Format is the same, The Data has been updated...

 

Thanks

Mat

Highlighted
Alteryx Partner

My solution

 

Spoiler
challenge_45_RODO_Solution.png
Highlighted
8 - Asteroid

Fun using the download tool!

 

Easy to do with guide alongside; thanks for the practice exercise.

8 - Asteroid
 
Highlighted
8 - Asteroid
Spoiler
challenge_45_solution_justindavis.PNG
Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid

My Effort

 

Spoiler
JamesCameron_0-1575034266278.png
Highlighted
Alteryx Partner