Challenge #22: Identify Values to Aggregate

[Normster]

I took a slightly different approach and came to the same conclusion.  (Instead of parsing to rows I parsed to columns and then transposed to finish the workflow). 

Normster

[PeterH23]

My solution

Spoiler

[myouree]

Solution attached.

[kaianderson]

Here's my solution!

[aheikes]

Spoiler

[atcodedog05]

On a spree to binge complete weekly challenges

Spoiler

This is my solution

[Ivyin702]

Spoiler

Regex is a wonderful tool. I use Token to parse all the amount and sum them together only using 4 tools. Make my life much easier 

[grossal]

Time to work on these challenges!

Spoiler

No-brainer to me! Regex for the win!

[steven4320555]

The vantage Alteryx icon is so colorful. Looks like screen shot for the purpose of the tools. Text input, browse and record ID are very visual.

Good practice for Regex, still a lot of try and error to get there. But I am less frustrated, and I was happy to saw my regex expression worked, especially the first tokenize one.

Spoiler

For the second parse regex, I had to adjust my initial Regex expression to accommodate the special case. And I worked. 

[Inactive User]

PFA the solution.