Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Roman to Integer conversion

AnandKumar1
8 - 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?

 

 

6 REPLIES 6
Thableaus
17 - Castor
17 - Castor

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,

LordNeilLord
15 - Aurora

Hey @AnandKumar1 

 

Here's my go at it

 

Capture.PNG

AnandKumar1
8 - Asteroid

@LordNeilLord That was awesome

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

JReid
9 - Comet

Just saying, this question would make an awesome weekly challenge

AYXAcademy
Alteryx
Alteryx

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