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" })