Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Roman to Integer conversion


This is a weird question but i've faced today with one of my data sheet.

I got data with roman numbers into it like I,II,III,IV,V etc till X(10). Though i've converted these numbers to integer using formula tool like if 'I' then 1 else 2 and so on. But i've to write it 10times for each number.


Is there a way to convert Roman numbers to Integer value?



Alteryx Certified Partner
Alteryx Certified Partner

Hi @AnandKumar1 


There's an add in created by @jdunkerley79 that contains a function with this ability to convert Roman values to integers.



You can check out in his blog:



Alteryx Certified Partner
Alteryx Certified Partner
Alteryx Certified Partner

Hey @AnandKumar1 


Here's my go at it




@LordNeilLord That was awesome

@Thableaus Thanks for sharing that link. Will try to use that too.


Just saying, this question would make an awesome weekly challenge

We think so, too @JReid !  Thanks @LordNeilLord  for sending this to our Weekly Challenge queue...can't wait to work it into the mix!