Comment on page
Table.FromPartitions
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" })
Last modified 5yr ago