Roman to Integer conversion

[AnandKumar1]

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?

[Thableaus]

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:

https://jdunkerley.co.uk/2019/04/09/an-overview-of-the-alteryx-abacus-add-in/

Cheers,

[Thableaus]

You may also check it here:

https://community.alteryx.com/t5/Engine-Works-Blog/An-Overview-of-the-Alteryx-Abacus-Add-In/ba-p/398...

[LordNeilLord · Accepted solution]

Hey @AnandKumar1 

Here's my go at it

[AnandKumar1]

@LordNeilLord That was awesome

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

[JReid]

Just saying, this question would make an awesome weekly challenge

[AYXAcademy]

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