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 in London on Thursday, 10th July, for an exclusive in-person Data Governance Masterclass featuring Nicola Askham – The Data Governance Coach. This event is designed for data leaders like you who are looking to enhance their governance strategies, gain insights from industry experts, and connect with peers through…