Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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

cplewis90
13 - Pulsar
13 - Pulsar
Spoiler
Challenge 53.PNG
JonathanAllenby
8 - Asteroid

Here's my solution to challenge 53!

hanykowska
11 - Bolide

I think I got it

TonyA
Alteryx Alumni (Retired)

My solution is similar to @SeanAdams and @NicoleJohnson .

Spoiler
I assumed the requirement to replace "#" and empty fields with "N/A" was global since I didn't see anyplace in the example where that replacement wasn't made so I did the replace while the data was in a single column before crosstabbing.

2019-04-13_11-22-24.jpg
T_Willins
14 - Magnetar
14 - Magnetar

My solution.

 

Spoiler
 Workflow 53.GIF

 

 

hbraunius
8 - Asteroid

My solution attached.

Thableaus
17 - Castor
17 - Castor

Challenge #53, done.

 

Spoiler
Challenge_53.PNG

Cheers,

Parinita
6 - Meteoroid

Hello,

 

You can find my solution for this challenge over here! This one is not the exact answer to this challenge but i tried my version.

Please feel free to ask any queries regarding this. Have a wonderful day!

bkclaw113
9 - Comet
 
Suzu
9 - Comet

Here is my solution.