community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #53: Parsing Report Formatted Data

Asteroid
Spoiler
Solution-Challenge 053.PNG
Asteroid

Here's my solution, without macro.

Spoiler
Capture.JPG
Asteroid

Solution attached.

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

Thank you for the exercise - please find attached my solution

Alteryx Certified Partner

My solution

Asteroid
 
Asteroid
Spoiler
2019-09-08 15_51_18-Greenshot.png
Asteroid

@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?

Pulsar

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

Highlighted
Asteroid

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