Truncate
You can use the Truncate operation to remove unnecessary characters or words from the end of text values in your data. To perform the truncate transform 1. Right-click the column and select the Truncate option from the context menu. 2. In the ...