We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #313: Base Converter

gawa
11 - Bolide

A solution to last week’s challenge can be found here.

 

When humans deal with numbers, decimal number (Base10) is common. But we can also represent values in other bases. For example, a hexadecimal number is in Base 16; one use of this system is to represent HTML color codes. Computers also use the binary (Base2) and hexadecimal number systems extensively!Weekly Challenge Image 313.png

 

Your task is to create a Base Converter by making an analytic application. Your app will convert the given decimal numbers into the specified base ‘n’ numbers. You have to configure the application interface so that user can specify the base ‘n’ (‘n’ must be set to integer between 2 and 16).

 

Note that number exceeding 10 is usually expressed in alphabet( 10->a, 11->b,,,). Please use the provided Integer to letter table to convert your answer to the correct format.

 

An example output is provided for Base 16.

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
313-A.jpg313-M.jpg

Iterative macro within analytic app
Spoiler
313-I.jpg313-R.jpg

Great challenge! 

AkimasaKajitani
15 - Aurora
15 - Aurora

My solution.

 

Spoiler
Workflow :
AkimasaKajitani_0-1649173603727.png
Macro :
AkimasaKajitani_4-1649173689066.png

 


UI:
AkimasaKajitani_2-1649173636122.png

Result:

AkimasaKajitani_3-1649173646993.png

 

 

 

 

mmontgomery
8 - Asteroid

App attached which includes iterative macro

Spoiler
mmontgomery_0-1649174534195.pngmmontgomery_1-1649174569347.pngmmontgomery_0-1649174662170.png

 

 

patrick_digan
17 - Castor
17 - Castor
Spoiler
I decided to use the alteryx abacus to avoid iterative macros and reference shortcuts to pass the variable into the generate rows tool. My workflow will error out if you don't have the abacus installed.

patrick_digan_0-1649176808041.png

 

PhilipMannering
15 - Aurora
15 - Aurora

Did the macro instead of an app ¯\_(ツ)_/¯

 

Spoiler
PhilipMannering_0-1649177096107.png

 

And the macro part,

Spoiler
PhilipMannering_1-1649177137694.png

 

binuacs
15 - Aurora
Spoiler
binuacs_0-1649177946579.png

 

Michael_Draper
7 - Meteor

Fun one! 

Spoiler
Used the reference shortcut I learned about this week! "%Question.Base%"

Michael_Draper_0-1649180999138.pngMichael_Draper_1-1649181059996.png

 

dYoast
8 - Asteroid

My macro could be better.

Spoiler
Workflow
dYoast_0-1649181807604.png


Macro

dYoast_1-1649181843478.png


Sample Run

dYoast_2-1649181903852.png

 

SPetrie
10 - Fireball

This was a fun one.

Went with an iterative macro.

Spoiler
SPetrie_0-1649189128668.png
SPetrie_1-1649189161789.png

 

 

Spoiler
SPetrie_2-1649189196845.pngSPetrie_3-1649189212077.png

 

 

 Edited to have the correct workflow version attached.