Alteryx Designer Desktop Discussions

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

Write an amount in letters

Keisi
6 - Meteoroid

Hi :)

Can anyone please help me to write amounts in letters
Example:
1,932
Would be converted to
One thousand nine hundred and thirty-two

 

Thanks a lot in advance

5 REPLIES 5
MarqueeCrew
20 - Arcturus
20 - Arcturus

@Keisi ,

 

 do you want to play with Python 🐍?

 

https://github.com/savoirfairelinux/num2words

 

@grossal or @clmc9601  might give you links to their articles or give you words of encouragement. 

i would solve it natively by parsing the number as text and writing my own logic. 

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
atcodedog05
22 - Nova
22 - Nova

Hi @MarqueeCrew 

 

Thank you for sharing this resource. The thing which got me excited about this package is the easy-to-use language support.

 

atcodedog05_0-1678010450550.png

 

@Keisi Python should be the preferred method to go unless your company has governance against python usage. If that's the case as @Yoshiro_Fujimori suggested refer to Challenges 234 & 235 for building the required logic.


Cheers and have a nice weekend you all !

atcodedog05
22 - Nova
22 - Nova

Hi @Keisi 

 

My post is just my comments of @MarqueeCrew and @Yoshiro_Fujimori posts. Theirs are the actual post which deserves to be marked as solution since they took the effort to find and suggest you a solution :)



Cheers and have a nice day!

 

Keisi
6 - Meteoroid

Thank you for your help @MarqueeCrew, I managed to solve it using Python as you suggested 🙂

Labels