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.
6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com
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 #183: Roman Numeral Math

9 - Comet

This was a tough one for me but I struggled my way through it. The help on the dynamic replace was a game changer.

Spoiler
9 - Comet

This one definitely took me the most time out of any of the ~60 weekly challenges I've completed thus far, but I'm glad it did because I picked up some new things - particularly the Dynamic Replace technique others have pointed out. Most notably, I'm glad to learn that...

Spoiler
... you don't need a macro to evaluate an expression stored in a field. You can just create a dummy field that contains the name of the field containing your expression, and use that one tool as the D and R inputs for the Dynamic Replace. Awesome!

10 - Fireball

I learnt Dynamic Replace via @Martyn, so thank you 😄

Spoiler
I did not round the answer, as I did not see a cue that I should
8 - Asteroid

Roman numerals took me back to primary school, nice little challenge!

Spoiler
12 - Quasar

Solution Attached

Alteryx

A very tough challenge, the logic in the multi-row formula is what gave me lots of trouble.

Some help from @DanielMS got me through it.

Spoiler
8 - Asteroid
Spoiler

Two ways to get there.

8 - Asteroid

Was stuck at the very last step until I previewed the posted solution and learned about Dynamic Replace. This is a tool I'm going to be trying to use get better with in the future. Always great to learn a new tool.

8 - Asteroid

8 - Asteroid

Here is my version.

Spoiler