Lezen in het Engels

Delen via


Table.Unpivot

Syntaxis

Table.Unpivot(table as table, pivotColumns as list, attributeColumn as text, valueColumn as text) as table

Over

Hiermee wordt een set kolommen in een tabel omgezet in kenmerk-waardeparen, gecombineerd met de rest van de waarden in elke rij.

Voorbeeld 1

Neem de kolommen 'a', 'b' en 'c' in de tabel ({[ key = "x", a = 1, b = null, c = 3 ], [ key = "y", a = 2, b = 4, c = null ]}) en herstructureer ze in attribuut-waardeparen.

Gebruik

Table.Unpivot(
    Table.FromRecords({
        [key = "x", a = 1, b = null, c = 3],
        [key = "y", a = 2, b = 4, c = null]
    }),
    {"a", "b", "c"},
    "attribute",
    "value"
)

uitvoer

Table.FromRecords({
    [key = "x", attribute = "a", value = 1],
    [key = "x", attribute = "c", value = 3],
    [key = "y", attribute = "a", value = 2],
    [key = "y", attribute = "b", value = 4]
})