How to remove null values from a column?
As part of your data preparation steps, you would want to discard records that contain null values for a given column. You can use the null operator to perform this action:
Step 1: When you create a new connection, you will get to Preview Screen.
Step 2: On preview screen, select the"remove null" from others section in drop down list as shown
Step 3: As and when you click on remove null, the system will apply the operation and will delete the null entries by deleting the rows.