We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
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