alteryx Community

# 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.

## Challenge #313: Base Converter

15 - Aurora

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!

17 - Castor

My solution.

Spoiler
Workflow :

Macro :

UI:

Result:

11 - Bolide

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.

16 - Nebula

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

Spoiler

And the macro part,

Spoiler

20 - Arcturus
Spoiler

7 - Meteor

Fun one!

Spoiler

11 - Bolide

My macro could be better.

Spoiler
Workflow

Macro

Sample Run

13 - Pulsar

This was a fun one.

Went with an iterative macro.

Spoiler

Spoiler

Edited to have the correct workflow version attached.