How to trim or remove whitespace from your data?
When working with unclean data, you would notice some text columns containing leading and trailing whitespaces which leads to a failed analysis or join. You can clean these columns using the remove whitespace operator. Following are the steps:
Step 1: When you create a new connection, you will get to Preview Screen.
Step 2: On preview screen, select the column you want to trim or remove whitespace from and click on down arrow.
Step 3: Click on trim or whitespace from the String Operations section of the drop-down list. You can either trim or remove whitespace by leading and trailing spaces or conditional statement.
Step 4: Select the one which you want to apply either trim or remove whitespace
Trim leading and trailing\/ remove whitespace : when you click on this option, it will directly apply the operation on whole column which is selected.
Conditional Trim \/ Conditional Removal : it will open a pop up where you can add your condition required and click on save changes to apply the operation on whole column which is selected.