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
6 - Meteoroid
Spoiler
 



It reads every number and assigns it a value, 1 that are before V or X will be -1.

 

Operators are assigned a value 0. a running number column is created to group them, with an operator increasing the number by 1. The first number will have the group 0

 

sum the numbers up and concat their operators by their group numbers, join them together, have a running multirow formula to perform the operators accordingly

 

Had to get some inspiration from the solutions on how to manage the negative 1. 

 

Nonetheless, got to the solution!

 

Created it to take on any form of roman numerals expressions, just need to modify number of columns in the regEx tool should the number of characters exceeds 1000.

 

 

Highlighted
5 - Atom

That was an interesting challenge! Here's my solution. Portions could definitely be a lot more elegant.

Highlighted
Alteryx Partner

My solution

 

Spoiler
challenge_183_RODO_Solution.png
Highlighted
Alteryx
Alteryx

Great - Challenge.

Highlighted
13 - Pulsar

Here is my solution

 

Spoiler
workflow.PNG
Highlighted
Alteryx Certified Partner

My solution seems overly complicated. 
On the bright side, I learned how to successfully use the R tool today.

I used R's eval function to evaluate the formula string.
I'm looking forward to seeing how this challenge SHOULD be done!

 

 

Spoiler
screenshot_183.png

 

 

Highlighted
Alteryx Partner

Here's my solution.  The hardest part was evaluating the formula from the data.  

Spoiler
I used a table of substitution to make the Roman numerals easier to evaluate.  For example, IX can be replaced with VIIII, and then you can replace all the numerals with their arabic equivalents and add them.  No looping or fancy logic required.  It was crazy hard to figure out how to set the dynamic replace tool to evaluate the resulting mathematical statement, but it finally worked.  An "EvaluateString()" function would have helped a lot
Highlighted
Alteryx Certified Partner

Here is my solution !

Highlighted
14 - Magnetar
14 - Magnetar

I'd love to figure out a more streamlined approach. Here's my go at it, not very different from anyone else.

 

Sometimes I do actually miss the INDIRECT function.....

Highlighted
8 - Asteroid

My solution: