Returns a table that is the result of combining a set of partitioned tables.
function (
partitionColumn
as text,partitions
as list, optionalpartitionColumnType
as nullable any) as table
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
.
Table.Row operations
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" })