Behavior of the On Null Property When Defining Variables in a Variable Map
When defining variables in a variable map, note that the On Null property behaves as follows:
If a path is specified for a variable, then that variable appears in the Row Set with whatever value is retrieved. In this instance, the On Null property is an empty string.
If no path is specified for a variable and the On Null property is set to Ignore, then the variable is not included in the Row Set.
If no path is specified for a variable, the On Null Property is set to Default, and a default value is specified, then the variable is included in the Row Set with the default value.