Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

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!