Table.FromPartitions

Tiek atgriezta tabula, kas ir iegūta, apvienojot nodalītu tabulu kopu.

Syntax

Table.FromPartitions(
    partitionColumn as text,
    partitions as list,
    optional partitionColumnType as type
) as table

Remarks

Atgriež tabulu, kas ir nodalītu tabulu kopas, partitions, apvienošanas rezultāts. partitionColumn ir pievienojamās kolonnas nosaukums. Kolonnas tips pēc noklusējuma tiek atiestatīts uz any, taču to var norādīt partitionColumnType.

Examples

Example #1

Atrodiet vienuma tipu sarakstā {number}.

Table.FromPartitions(
    "Year",
    {
        {
            1994,
            Table.FromPartitions(
                "Month",
                {
                    {
                        "Jan",
                        Table.FromPartitions(
                            "Day",
                            {
                                {1, #table({"Foo"}, {{"Bar"}})},
                                {2, #table({"Foo"}, {{"Bar"}})}
                            }
                        )
                    },
                    {
                        "Feb",
                        Table.FromPartitions(
                            "Day",
                            {
                                {3, #table({"Foo"}, {{"Bar"}})},
                                {4, #table({"Foo"}, {{"Bar"}})}
                            }
                        )
                    }
                }
            )
        }
    }
)

Result:

Table.FromRecords({
    [
        Foo = "Bar",
        Day = 1,
        Month = "Jan",
        Year = 1994
    ],
    [
        Foo = "Bar",
        Day = 2,
        Month = "Jan",
        Year = 1994
    ],
    [
        Foo = "Bar",
        Day = 3,
        Month = "Feb",
        Year = 1994
    ],
    [
        Foo = "Bar",
        Day = 4,
        Month = "Feb",
        Year = 1994
    ]
})

Category

Table.Row operations