Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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