Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

bnelly1987
8 - Asteroid
Spoiler
Solution-Challenge 053.PNG
Marcel_Gavrila
8 - Asteroid

Here's my solution, without macro.

Spoiler
Capture.JPG
KMiller
8 - Asteroid

Solution attached.

Spoiler
16-08-2019 08-34-09.png
FRANCK_ROUQUETTE
8 - Asteroid

Thank you for the exercise - please find attached my solution

Hannah_Lissaman
11 - Bolide

My solution 🙂

Carlithian
11 - Bolide
11 - Bolide
 
mbogusz
9 - Comet
Spoiler
2019-09-08 15_51_18-Greenshot.png
mbogusz
9 - Comet

@estherb47I went to open up your solution, but it was the solution for the previous challenge. I was interested in seeing your application of the Smart Tile tool. I know this one might feel like digging up old bones, but if you do have it handy can you please re-reply with the solution for this challenge- Challenge #53?

estherb47
15 - Aurora
15 - Aurora

Hi @mbogusz 

Whoops!!! Fixing that now with the correct workflow.......

 

Now I'd probably solve it differently, with a bit more RegEx and the Tile tool using Unique Value (one of my favorites!)

Cheers,

Esther

mbogusz
9 - Comet

Thank you very much @estherb47.  It looks like the Smart Tile tool accomplishes what a multi-row formula tool with Group by and some +1 logic can do, but more nicely without having to write out a formula.  Going to add this to my Alteryx bag of tricks 🙂