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

KTH_LARGEST_UNIQUE

Returns the kth largest unique number from the selected source columns in a new column.

Parameters

  • sourceColumns – A JSON-encoded string representing a list of existing columns.

  • targetColumn – A name for the newly created column.

    value – A number representing k.

Example

{
    "RecipeAction": {
        "Operation": "KTH_LARGEST_UNIQUE",
        "Parameters": {
            "sourceColumns": "[\"age\",\"height_cm\",\"weight_kg\"]",
            "targetColumn": "KTH_LARGEST_UNIQUE Column 1",
            "value": "3"
        }
    }
}