Task Factory Null Handler Transform

Null Handler Transform

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

Option	Description
Input Column	The name of the input column.
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.

Option

Description

Input Column

The name of the input column.

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.

Task Factory Null Handler Transform Account Key

Additional Information: See the Task Factory Error Row Handling article for more information about this functionality.