Challenge #53: Parsing Report Formatted Data

[bnelly1987]

Spoiler

[Marcel_Gavrila]

Here's my solution, without macro.

Spoiler

[KMiller]

Solution attached.

Spoiler

[FRANCK_ROUQUETTE]

Thank you for the exercise - please find attached my solution

[Hannah_Lissaman]

My solution 🙂

[mbogusz]

Spoiler

[mbogusz]

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

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]

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 🙂