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

EricaR
Alteryx
Alteryx

Solution Attached

CKP
10 - Fireball

My solution

 

Spoiler
challenge_53_mysolution.jpg
RobertOdera
13 - Pulsar

Feels like I took the scenic route on this one.

I will definitely review other posts for a shorter approach.

 

Spoiler
RNO2_0-1589977506214.png

 

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !

JeremyGonzva
8 - Asteroid

RegEx to the rescue!

 


AngelosPachis
16 - Nebula

Challenge #56 solved

 

Spoiler
Annotation 2020-06-06 175243.png
deviseetharaman
11 - Bolide
Spoiler
 
Parul_Kapoor
8 - Asteroid

Sol attached

jarrod
ACE Emeritus
ACE Emeritus

I've actually made a macro to deal with this type of process where you don't know how many fields but decided to detail it out in the workflow:

Spoiler
jarrod_0-1591817328112.png

 

cc000072
8 - Asteroid

Here is my solution.

Spoiler
WeeklyChallenge_Ryohei_53.JPG