We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start 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

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! 😄

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