We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
The Alteryx Community has implemented a new single sign-on experience. If you are having issues with your account, please review the FAQs.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #53: Parsing Report Formatted Data

paulburrows
8 - Asteroid

Enjoyable 🙂

maheensayeed
8 - Asteroid

Here's my solution

chris_ramsay
8 - Asteroid

Thanks for the challenge, here's my solution

mikeprice17
8 - Asteroid

My Solution

Chantelbbr
8 - Asteroid
Spoiler
Chantelbbr_0-1581290320982.png
Reesetrain
8 - Asteroid

All,

 

My solution, without a MACRO is attached!

Spoiler
Capture.PNG
LevL
7 - Meteor

took me a while to realise that text to columns can be text to rows...

Spoiler
LevL_0-1581519041285.png

 

Nicholas_Bignell
8 - Asteroid
 
johnemery
10 - Fireball

I'm guessing Text To Columns didn't exist in earlier versions of Alteryx... I'm glad it does now!

 

Spoiler
Capture.PNG

 

 

Blake
12 - Quasar
Spoiler
Blake_0-1581973488237.png

 

Quick and easy parsing.