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

The "SuperCleanup" tool

It seems that there is good value in a "SuperCleanup" tool that could take commonly used ways of writing information and cleaning this up automatically.    This would work well if the tool reviewed the data in the column, and made a recommendation about the cleanup to apply.    The tool could cleanup the data; and then pop any non-conforming values into a separate column for you to explictly clean up.    

 

For example:

- 01 Jan 2015: this can be automatically cleaned up into a date

- 11:15 pm: this can be cleaned up into a time

40.7128° N, 74.0060° W; or 40° 43' 50.1960'' N and 73° 56' 6.8712'' W:    Both could be auto-converted to a centroid

- $ 55.20 or  £2,000,000.00 can be automatically converted to currency

- India; United States; Mongolia - can be automatically cleaned up as a country (there are only about 200 or so in the world, so it's a very finite list)

- NY; AZ; MI; can be cleaned up as US states

NOTE: if we make this extensible -then companies can auto cleanup SKUs; or location codes; etc

 

There are dozens of simple cleanups like this that we could add - which would each relieve BI people from the drudgery of having to clean these up each time themselves.

2 Comments
SeanAdams
17 - Castor
17 - Castor

Project Maestro just demonstrated something which is a related capability- i.e. the ability to visually clean up data.

 

Imagine if we can augment Alteryx to allow for:

- The super cleanup tool above, which uses basic machine learning to identify the data that you're trying to use

- Then it identifies anomalies

- And when you tell Alteryx how to deal with these - it automatically inserts tools on the canvas to execute cleanup that you performed visually.

 

This would be SUPER powerful

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