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.