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.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.