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.

SUBMIT YOUR IDEA

Challenge #418: To the Nth Degree and Beyond

MitchyMitch
8 - Asteroid

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

Spoiler
Challenge 418.png

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

Sebastian_Chaieb2
8 - Asteroid
8 - Asteroid

Great task 👍

 

Spoiler
418.PNG


Congrats for @achisman for solving it without Summarize tool 

Reesetrain2
9 - Comet

All,

 

My solution: 

Spoiler
Screenshot 2024-03-20 152653.png

CSmith16
9 - Comet

My Take On This:

 

Workflow:

Spoiler
Workflow.png

Solution:

Spoiler
Workflow.pngWorkflow.png

 Bonus Question:

Spoiler
Workflow.pngWorkflow.png

 Formulas:

Spoiler
FORMULAS.png
FORMULAS 1.png
FORMULAS 2.pngFORMULAS 3.pngFORMULAS 4.pngFORMULAS 5.png
CSmith16
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.

ARussell34
8 - Asteroid

I found the 13 values!

AR_418.png

Powerhouse_21
9 - Comet
Spoiler
418.png

Andrew_D
7 - Meteor
Spoiler
Solution.png

Pipo
6 - Meteoroid
Spoiler
Screenshot 2024-03-22 070140.png

DaisukeTsuchiya
13 - Pulsar
Spoiler
スクリーンショット 2024-03-23 173207.png