此頁面尚未翻譯為您的語言。 請求翻譯

PIVOT

PDFRSS

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

Parameters

• sourceColumn — The name of an existing column. The column can have a maximum of 10 distinct values.

• valueColumn — The name of an existing column. The column can have a maximum of 10 distinct values.

• aggregateFunction — The name of an aggregation function. If you don't want aggregation, use the keyword COLLECT_LIST.

Example

{
    "Action": {
        "Operation": "PIVOT",
        "Parameters": {
            "aggregateFunction": "SUM",
            "sourceColumn": "state_name",
            "valueColumn": "all_votes"
        }
    }
}