In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start 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

kcgreen
8 - Asteroid

I was stuck until I peeked at some of the solutions and saw the text to columns tool could be used for text to rows as well.   From there I just multi-rowed my way to a solution.  

 

Spoiler

 

45.JPG

 

Gauthier_B
8 - Asteroid

Done!

Was a fun challenge, took me a while to figure it out.

OllieClarke
16 - Nebula
16 - Nebula

Learnt a lot during this one :)

 

Spoiler
Challenge 45.PNG
TimothyManning
8 - Asteroid
Spoiler
45. Data Parsing Screenshot.png
robbinrv
8 - Asteroid

My workflow below

 

Spoiler
Spoiler
Alt_Chal_45.PNG
paul_houghton
12 - Quasar

Another one done :)

 

Spoiler
Challenge 45 Complete.jpg
asabau
8 - Asteroid

Nice practice of Regex!

KOBoyle
11 - Bolide

Solution attached.

dsmdavid
11 - Bolide

Went a different (and looonger road). Nested macros.

 

Spoiler
Main workflowMain workflowFirst Batch MacroFirst Batch MacroInside Batch MacroInside Batch Macro
justynam
8 - Asteroid

Challenge solved!