DropNullFields
Specifies a transform that removes columns from the dataset if all values in the column are 'null'. By default, AWS Glue Studio will recognize null objects, but some values such as empty strings, strings that are "null", -1 integers or other placeholders such as zeros, are not automatically recognized as nulls.
Contents
- Inputs
-
The data inputs identified by their node names.
Type: Array of strings
Array Members: Fixed number of 1 item.
Pattern:
[A-Za-z0-9_-]*
Required: Yes
- Name
-
The name of the transform node.
Type: String
Pattern:
([^\r\n])*
Required: Yes
- NullCheckBoxList
-
A structure that represents whether certain values are recognized as null values for removal.
Type: NullCheckBoxList object
Required: No
- NullTextList
-
A structure that specifies a list of NullValueField structures that represent a custom null value such as zero or other value being used as a null placeholder unique to the dataset.
The
DropNullFields
transform removes custom null values only if both the value of the null placeholder and the datatype match the data.Type: Array of NullValueField objects
Array Members: Minimum number of 0 items. Maximum number of 50 items.
Required: No
See Also
For more information about using this API in one of the language-specific AWS SDKs, see the following: