이 페이지는 귀하의 언어로 번역되지 않았습니다. 번역 요청

UNPIVOT

PDFRSS

Converts all the column values in a selected row into individual rows with 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"
        }
    }
}