STRING_GREATER_THAN - 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).

STRING_GREATER_THAN

Creates a new column populated with one of the following:

  • True if one string in a column (or value) is greater than another string in a different column (or value).

  • False if there is no match.

Parameters

  • sourceColumn1 – The name of an existing column.

  • sourceColumn2 – The name of an existing column.

  • value1 – A character string to evaluate.

  • value2 – A character string to evaluate.

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

Note

You can specify only one of the following combinations:

  • Both of sourceColumnN.

  • One of sourceColumnN and one of valueN.

  • Both of valueN.

Example

{
    "RecipeAction": {
        "Operation": "STRING_GREATER_THAN",
        "Parameters": {
            "sourceColumn1": "first_name",
            "sourceColumn2": "last_name",
            "targetColumn": "string_greater_than"
        }
    }
}