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

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

gawa
16 - Nebula
16 - Nebula

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
17 - Castor
17 - Castor

My solution.

 

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

 


UI:
AkimasaKajitani_2-1649173636122.png

Result:

AkimasaKajitani_3-1649173646993.png

 

 

 

 

mmontgomery
11 - Bolide
11 - Bolide

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
16 - Nebula
16 - Nebula

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

 

Spoiler
PhilipMannering_0-1649177096107.png

 

And the macro part,

Spoiler
PhilipMannering_1-1649177137694.png

 

binuacs
21 - Polaris
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
11 - Bolide

My macro could be better.

Spoiler
Workflow
dYoast_0-1649181807604.png


Macro

dYoast_1-1649181843478.png


Sample Run

dYoast_2-1649181903852.png

 

SPetrie
13 - Pulsar

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.