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

Jonathan-Sherman
15 - Aurora
15 - Aurora

A nice simple way to go about it!

 

Spoiler
challenge 53 JMS solution.PNG
Vidya26
8 - Asteroid

My Solution!!

nickjastrzebski
8 - Asteroid

No macro here, but should function dynamically with varying numbers of columns. The only part that isn't dynamic is the clientid field as this has a different formatting requirement to clienttimeprop.

 

Spoiler
image.png
piotrzawistowski
8 - Asteroid
 
Verakso
11 - Bolide

Here is my take, not using macro, but I still believe it is dynamic...

Spoiler
Well sort of, there still is the "assumption" that the data starts with a pipe character, and therefore it is filtered out 😮

2019-07-25 12_41_29-Alteryx Designer x64 - challenge_53_start_file.yxmd_.png

 

Still Climbing
/Verakso

Cosmin_S
8 - Asteroid

My solution (similar to others).

smoskowitz
12 - Quasar

This was a good one. Had me think for a while. Loved it!

smoskowitz
12 - Quasar

My solution attached! 😄

arein0
8 - Asteroid
Spoiler
53.png
fmeo
8 - Asteroid
Spoiler
53.PNG