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.
alteryx Community

# 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

12 - Quasar

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!

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.

16 - Nebula
Spoiler

Iterative macro within analytic app
Spoiler

Great challenge!

16 - Nebula

My solution.

Spoiler
Workflow :

Macro :

UI:

Result:

8 - Asteroid

App attached which includes iterative macro

Spoiler

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.

15 - Aurora

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

Spoiler

And the macro part,

Spoiler

18 - Pollux
Spoiler

7 - Meteor

Fun one!

Spoiler

10 - Fireball

My macro could be better.

Spoiler
Workflow

Macro

Sample Run

11 - Bolide

This was a fun one.

Went with an iterative macro.

Spoiler

Spoiler

Edited to have the correct workflow version attached.