Start Free Trial

Alteryx Designer Desktop Discussions

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

Numeric to Currency Formatter

juliussorensen
6 - Meteoroid

I am interested in creating a macro which allows for the following 3 things:

 

1. Convert a numeric field to a string field  (I have this part figured out)

2. Asks the user if they are interested in adding any of the following to the strings selected: $, £, DKK, SEK, NOK, % etc

3. Asks if the selected input should be before or after the selected string field

 

Thanks in advance

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @juliussorensen 

 

Build the app like this.

atcodedog05_0-1662112067326.png

 

Then convert  text input tool and browse tool to macro input and output by right-clicking and selecting option like below

atcodedog05_1-1662112108150.png

 

Make sure to save it as an macro by selecting options below

atcodedog05_2-1662112259338.png

 

Go through the below interactive lessons to get a better understanding of using Macro and Apps

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Creating%2...

https://community.alteryx.com/t5/Interactive-Lessons/Creating-a-Standard-Macro/ta-p/657918

 

Hope this helps : )

 

 

 

juliussorensen
6 - Meteoroid

Thank you so much :) That solved my issue

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @juliussorensen 

Cheers and have a nice day!

Labels
Top Solution Authors