Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Roman to Integer conversion

Highlighted
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?

 

 

Highlighted
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,

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
Highlighted
Alteryx Certified Partner

Hey @AnandKumar1 

 

Here's my go at it

 

Capture.PNG

Highlighted
8 - Asteroid

@LordNeilLord That was awesome

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

Highlighted
9 - Comet

Just saying, this question would make an awesome weekly challenge

Highlighted
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