Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
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.

Challenge #183: Roman Numeral Math

Highlighted
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
WC 183 Roman Numerals.png
Highlighted
8 - Asteroid

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!

challenge_183_solution_justindavis.PNGchallenge_183_solution_justindavis_note.PNGchallenge_183_solution_justindavis_note_2.PNG
Highlighted
Alteryx Certified Partner

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 shouldI did not round the answer, as I did not see a cue that I should
Highlighted
8 - Asteroid

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

 

Spoiler
clipboard_image_0.png
Highlighted
11 - Bolide

Solution Attached

Highlighted
Alteryx
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
James Marks Week 183.PNG
Alteryx Certified Partner
Spoiler
キャプチャ.JPG

Two ways to get there.

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

Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid

Here is my version.

Spoiler
ganesamurthy_1-1572102169586.png