Drop Empty Cells
The Drop Empty Cells transformer allows you to empty row values by selecting columns and choosing what to drop.
Drop Empty Cells Transform dialog is shown as below:
-
Enter Title for this transform step. Ensure that the Title is uniquely identifying the step
-
Optionally, Enter Description to provide further information for this particular step. This is helpful in ensuring readability of the step in a large workflow.
-
Select column(s) for which replace operation needs to be performed using Select Column.
-
User has the option to choose how do they want to drop empty cells.i
-
Click Create to add the step to the recipe.
Supported options under Empty cells are :
- Drop records where all selected column values` are empty
- Drop records where any selected columns values are empty
