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

in-DB Cleanse Tool

I use the cleanse tool a lot to remove extra spaces before and after my data.  Since most of my work is done in-DB, I have to datastream out, cleanse, and then datastream back in.  Would love to see an In-DB Cleanse tool added.

2 Comments
AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes
 
JMB001
8 - Asteroid

I'd say that cleaning whitespace is really easy in SQL with TRIM() and REPLACE(), but what's a little more complicated is imputation and null cleansing which you can do with the non-in-db Cleansing Tool.