FLAG_COLUMN_FROM_NULL - Amazon Glue DataBrew
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

FLAG_COLUMN_FROM_NULL

Creates a new column, based on the presence of null values in an existing column.

Parameters

  • sourceColumn – The name of an existing column.

  • targetColumn – The name of a new column to be created.

  • flagType – A value that must be set to Null values.

  • trueString – A value for the new column, if a null value is found in the source. If no value is specified, the default is True.

  • falseString – A value for the new column, if a non-null value is found in the source. If no value is specified, the default is False.

Example

{
    "RecipeAction": {
        "Operation": "FLAG_COLUMN_FROM_NULL",
        "Parameters": {
            "flagType": "Null values",
            "sourceColumn": "weight_kg",
            "targetColumn": "is_weight_kg_missing"
        }
    }
}