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…
Join us for our upcoming Data Management User Group! Get exclusive insights into the latest plans, hear how leading organisations are tackling real world data challenges, join expert-led discussions on today’s most pressing data issues. We look forward to seeing you there.
