Table.FromPartitions

Table.FromPartitions
Returns a table that is the result of combining a set of partitioned tables.
function (partitionColumn as text, partitions as list, optional partitionColumnType as nullable any) as table
Description
Returns a table that is the result of combining a set of partitioned tables, partitions. partitionColumn is the name of the column to add. The type of the column defaults to any, but can be specified by partitionColumnType.
Category
Table.Row operations
Examples
Find item type from the list {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"} })
                                    }
                                }
                            )
                        }
                    }
                )
            }
        })
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 ] }, { "Foo", "Day", "Month", "Year" })

Table.FromList

Table.FromRecords

Last modified 3yr ago

Copy link

On this page

Table.FromPartitions

Description