NULL Handler

Parent Previous Next


Null Handler Transform


The "Null Handler Transform" allows the user to replace null or empty data with user specified data.



  Input Columns

o   Input Column - The name of the input column

o   Choose Action - There are three actions that can be defined to replace null or blank data

 Replace Null Value with User Defined Value - This action is used to replace null data with a user defined value.

 Replace Blank Value with Null - This action is used to replace blank values with null value. This is important where systems depend on data being null in a column.

 Replace Blank Value with User Defined Value - This action is used to replace empty strings with a user defined value.



Please see the Error Row Handling page for more information about this functionality.