community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Roman to Integer conversion

Asteroid

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:

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

 

Cheers,

Alteryx Certified Partner
Alteryx Certified Partner
Highlighted
Alteryx Certified Partner

Hey @AnandKumar1 

 

Here's my go at it

 

Capture.PNG

Asteroid

@LordNeilLord That was awesome

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

Asteroid

Just saying, this question would make an awesome weekly challenge

Asteroid

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

Labels