View a markdown version of this page

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

UNPIVOT

Converts all the column values in a selected row into individual rows with values.

Table transformation from wide format with three columns to long format with column names and values.
Parameters

  • sourceColumns — A JSON-encoded string representing a list of one or more columns to be unpivoted.

  • unpivotColumn — The value column for the unpivot operation.

  • valueColumn — The column to hold unpivoted values.

Example

{
    "Action": {
        "Operation": "UNPIVOT",
        "Parameters": {
            "sourceColumns": "[\"idealpoint_estimate\"]",
            "unpivotColumn": "unpivoted_idealpoint_estimate",
            "valueColumn": "unpivoted_column_values"
        }
    }
}