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…
