Challenge #418: To the Nth Degree and Beyond

[MitchyMitch]

I could probably simplify the workflow now that I've gone through it, but done = done. 😁 Good Challenge!! 

Spoiler

 Looking at everyone else's solutions, I certainly took the long route! 🤣🤣

[Sebastian_Chaieb2]

Great task 👍

Spoiler

Congrats for @achisman for solving it without Summarize tool 

[Reesetrain2]

All,

My solution: 

Spoiler

 

[CSmith16]

My Take On This:

Workflow:

Spoiler

Solution:

Spoiler

 Bonus Question:

Spoiler

 Formulas:

Spoiler

[CSmith16]

---

@ksukhraj wrote:

My solution is long, looking at it I think I know nothing about alteryx. But after creating this solution I understood following things (which will help me shorten it):

1. Tonumber() function

2. RegEx Tokenize

3. Using formula in filter

However, I am still posting the original solution, the longer version. 

---

@ksukhraj Imagine everyone's dismay looking at @gawa's solution. That right there is impressive.

Don't get down on yourself though, commenting on things like this and recognizing what to do better net time is what will make you better. Don't compare yourself to anyone but yourself.

[ARussell34]

I found the 13 values!

[Powerhouse_21]

Spoiler

 

[Andrew_D]

Spoiler

 

[Pipo]

Spoiler

 

[DaisukeTsuchiya]

Spoiler