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.
We are aware of an issue with the Search bar. Please use Advanced search for the time being while we troubleshoot. Thanks for your patience as we work on improving the community!
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