ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start 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 #313: Base Converter

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

 

Spoiler
Weekly_Challenge_313.JPG
aaziz2
8 - Asteroid

solution attached

olga_strubbe
11 - Bolide

Thank you, @gawa!  This was a tough one.

I leveraged the solution from @RolandSchubert  with a single macro.  Thank you both, @gawa  and Roland, for sharing your expertise on this. 

Workflow:

2024-01-16_13-40-01.png

 

Macro:

2024-01-16_13-39-11.png

 

Macro:

olga_strubbe
11 - Bolide

A quick edit to the solution I just submitted: you can convert 'Integer to Letter' input to a macro input - this way, you can update this reference table at anytime without having to modify the macro :)

alisonpitt
11 - Bolide

Funny how sometimes you're trying to solve a work conundrum and a weekly challenge turns out to be exactly what you need!

Spoiler
challenge-313-ap-macro.pngchallenge-313-ap-main.png
Erin
11 - Bolide

Honestly, I had no freaking idea about this one. I appreciate the examples of other bases but didn't get from the examples how the answer was derived - typical human. Thankfully there are plenty of other posted solutions to piggyback off of! 

 

Workflow:

Spoiler
C313.png

Macro

Spoiler
313_Macro.png

 

Bobbyt23
13 - Pulsar

A real head scratcher this one.

3I_ATLAS
9 - Comet

One of the best challenges (and perhaps the hardest!) I've tried so far!  THANK YOU @gawa !!! 😀

Took me some thinking and sleeping on it, but very happy with my final solution!  I can't believe I actually did it!

Along with figuring out the macro which surprisingly didn't take long, the other harder part was trying to figure out the algorithm for the base conversion.  Once that was done, adapting it for bases greater than 10 was straight forward.  I chose to limit from bases 2 to base 32 (max), but if we use additional non-letter/number characters, the code should work for any base size.

Anyway, loved it!  Thanks again for this creative puzzle!

 

The interface and Results:

Spoiler
WC_313_InterfaceResults.jpg

The flow:

Spoiler
WC_313.jpg

The macro:

Spoiler
WC_313_macro.jpg
lwolfie
11 - Bolide

Nice wrap up to my week.  I'm getting better with the iterations.

amruthas1287
7 - Meteor

Hi Check out the analytic app I created. This one uses an iterative macro to convert any list of numbers to any base between 2 to 16.