Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

New Money Datatype or Function

Alteryx is brilliant at handling dates and understands them natively. Very often businesses want to analyse money, and in all sorts of ways. In Alteryx if a column contains $123.45 Alteryx thinks it is a string, and one then has to mess around converting it to a number. Alteryx should recognise that anything like $123.45 or €123 or £1,234,567 is actually money and is a number not a string. This could be achieved either by  having a money datatype (like MS Access) or if that is too hard, a function that converts a string version of money into a number irrespective of padding, commas or decimal points.

 

Regards

Mark

4 Comments
jonathandrummey
7 - Meteor

Same goes for columns like 12.3%. 

SeanAdams
17 - Castor
17 - Castor

:-) while I agree with the sentiment and have a similar issue, not sure that I would tackle it by adding a range of additional types because the more types you add, the more you have compatabilty issues with every different data-store type on earth.

 

I think it would be helpful to have an option to format strings more visually (like Excel offers)- and then you can use the data-cleanse macro that comes with Alteryx 11 to strip back 12.5% to 12.5 or $23.252 to 23.252

 

2017-06-01_9-01-39.png

JonesJ
5 - Atom

This is a huge 'bug' for our teams.  All of our currency fields are stored as money instead of decimals.  Each field that is stored as money comes in as a string.  EVERY user has to convert that string to a double on every field.  As you can imagine, this is cumbersome and inefficient for the users of our organization.  Given "money" is a valid data type, can we get Alteryx to recognize it???

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes