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

sammyb84
5 - Atom
Spoiler
iteration macro.JPGapp for 313.JPG

 

 

 

 

 

 

 

I mostly copied Michael Draper's solution but used Kenda's Question.Name to update the Base.  I love how simple it is.

I love any feedback and I did test this so I know the macro works.  My main learning from Mr Draper on iterative macros is that you have to have same fields coming out of iterative output of the macro as those going right before the macro.  So in my case only have 3 fields (Decimal, Original Number and Base)  Make sure they are in this order as well (same field positioning).  Another callout is that if you use the '%Question.Name%' in your formula tool, the workflow will throw error as it only works with the App running, you could hardcode a string or number to get around it for testing.  For grouping I didn't use record ID, I used Kenda's original number and sorted Engine.Iteration before summary tool.  I banged my head on this one for a little while but it is rewarding to understand it better.

alineruizcampos
8 - Asteroid
Spoiler
Screenshot 2025-06-11 152958.pngScreenshot 2025-06-11 153017.png
Carolyn
12 - Quasar
12 - Quasar

Solved!

 

Spoiler
App.png

 

2025-06-15 11_04_00-Alteryx Designer x64 - Weekly Challenge 313_Carolyn.yxwz.png

 

Macro.png
JBevan89
8 - Asteroid

Difficult to Get your Head round

Pilsner
13 - Pulsar

Great challenge! Here's my solution:

Spoiler
Workflow:
313.png
Macro:
313 (macro).png