community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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 #53: Parsing Report Formatted Data

paulburrows
8 - Asteroid
‎01-27-2020 03:50 AM

Enjoyable 🙂

challenge_53_start_fileDOne.yxmd
Reply
0 Likes
maheensayeed
8 - Asteroid
‎01-28-2020 08:06 PM

Here's my solution

challenge_53_start_file_maheen.yxmd
Reply
0 Likes
chris_ramsay_dup_425
8 - Asteroid
‎01-30-2020 09:00 AM

Thanks for the challenge, here's my solution

challenge_53_solved.yxmd
Reply
mikeprice17
8 - Asteroid
‎02-04-2020 10:51 AM

My Solution

challenge_53_MySolution_file.yxmd
Reply
0 Likes
Chantelb
9 - Comet
‎02-09-2020 03:18 PM
Spoiler
Chantelbbr_0-1581290320982.png
challenge_53_CB.yxmd
Reply
0 Likes
Reesetrain2
9 - Comet
‎02-10-2020 06:25 PM

All,

 

My solution, without a MACRO is attached!

Spoiler
Capture.PNG
Challenge_53_Reesetrrain.yxzp
Reply
0 Likes
LevL
7 - Meteor
‎02-12-2020 06:50 AM

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

Spoiler
LevL_0-1581519041285.png

 

Reply
0 Likes
Nicholas_Bignell
8 - Asteroid
‎02-13-2020 04:10 AM
 
challenge_53_Solution_file.yxmd
Reply
0 Likes
johnemery
11 - Bolide
‎02-14-2020 05:40 PM

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

 

Spoiler
Capture.PNG

 

 

Challenge 53 Solution.yxmd
Reply
0 Likes
Blake
12 - Quasar
‎02-17-2020 01:10 PM
Spoiler
Blake_0-1581973488237.png

 

Quick and easy parsing.

challenge_53_start_file_BH.yxmd
Reply
0 Likes
curated machine learning resources