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.