Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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

sophiezero
7 - Meteor

This challenge is fun, changing the type of field and manipulation is interesting, and I also get a better understanding of the generate row tool :)

OzlemSigbeku
8 - Asteroid
Spoiler
418.png

Chose a brute force method - good fun.

Bobbyt23
12 - Quasar

Really interesting.

Spoiler
I never new there was a POW() calculation!
HardikJani
8 - Asteroid

A great challenge, for the first part the logic was to split the characters (used regex "."), add them and raised to the power of the length of original number. For the second part it was a bit tricky but a formula tool with an if function worked fine reducing the power by (1) each time

CASaiRam
7 - Meteor

This challenge , it took a while to understand and frame my approach to solving it. But i was unable to get the solution. I checked the solution available. moving forward i  need to practice a lot.

OlonJohnson
5 - Atom

Using tokenization to separate each character within the number column enables the use of the required formula that filters out ineligible numbers

GGGDias
8 - Asteroid

Simplest RegEx ever to the rescue

Spoiler
Challenge_418_Solution.png
fesrimo
8 - Asteroid

The Weekly Challenge are very intereting, I was solving multiple of them.

My solutions for challenge Weekly #418

ScottLewis
11 - Bolide

Solution has some extra logic up front to test if the nth root is an integer. This lets us throw out most values before we parse strings to get sum of numbers. 

Don't know how much that actually speeds things up for this example, but I like to optimize for execution time where possible and generally workflow tools are fast and RegEx is slow so we try to move the load off of the RegEx operation, even if this is the simplest possible RegEx.

 

As a bonus, structuring the problem this way made the extra credit easy. Once you're calculating nth roots, you just have to test all n<=length rather than just n=length and that sounds like a job for generate rows.

trepryor
8 - Asteroid

418 solution.png