alteryx Community

# 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.

## Challenge #418: To the Nth Degree and Beyond

8 - Asteroid

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! 🤣🤣

8 - Asteroid

Spoiler

Congrats for @achisman for solving it without Summarize tool

9 - Comet

All,

My solution:

Spoiler

9 - Comet

My Take On This:

Workflow:

Spoiler

Solution:

Spoiler

Bonus Question:

Spoiler

Formulas:

Spoiler

9 - Comet

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

8 - Asteroid

I found the 13 values!

9 - Comet
Spoiler

7 - Meteor
Spoiler

6 - Meteoroid
Spoiler

13 - Pulsar
Spoiler