Step 1: When you create a new connection, for example as shown here in Connect To hadoop article, 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.
