Roman to Integer conversion
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You may also check it here:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@LordNeilLord That was awesome
@Thableaus Thanks for sharing that link. Will try to use that too.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Just saying, this question would make an awesome weekly challenge
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
We think so, too @JReid ! Thanks @LordNeilLord for sending this to our Weekly Challenge queue...can't wait to work it into the mix!
