Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Hi there, does anyone know a function to clean whitespaces but leave one space between names? The equivalent of TRIM in excel. Thanks 😉
Here's a simple example of how you can remove leading or trailing characters. Assume you have loaded a dataset, treating all columns as alphanumeric as follows: To remove the leading zeroes from Customer No, apply the Trim function in a Transform step. To remove the trailing colon symbol from Customer ID, use the Trim…
This will be a special User Group event for us as we have an opportunity to share a real milestone in our product innovation. Our ‘new’ Aperture Data Studio is ready, and we’d love to have the opportunity to celebrate the enhanced capabilities together! We know you love data – by coming along you can exchange with your…
