Table.Split
Table.Split(table as table, pageSize as number) as list
Rozdelí table
do zoznamu tabuliek, kde prvým prvkom zoznamu je tabuľka obsahujúca prvé pageSize
riadky zo zdrojovej tabuľky. Ďalším prvkom zoznamu je tabuľka obsahujúca ďalšie pageSize
riadky zo zdrojovej tabuľky atď.
Rozdelí tabuľku s piatimi záznamami na tabuľky s dvomi záznamami.
používania
let
Customers = Table.FromRecords({
[CustomerID = 1, Name = "Bob", Phone = "123-4567"],
[CustomerID = 2, Name = "Jim", Phone = "987-6543"],
[CustomerID = 3, Name = "Paul", Phone = "543-7890"],
[CustomerID = 4, Name = "Cristina", Phone = "232-1550"],
[CustomerID = 5, Name = "Anita", Phone = "530-1459"]
})
in
Table.Split(Customers, 2)
výstupu
{
Table.FromRecords({
[CustomerID = 1, Name = "Bob", Phone = "123-4567"],
[CustomerID = 2, Name = "Jim", Phone = "987-6543"]
}),
Table.FromRecords({
[CustomerID = 3, Name = "Paul", Phone = "543-7890"],
[CustomerID = 4, Name = "Cristina", Phone = "232-1550"]
}),
Table.FromRecords({
[CustomerID = 5, Name = "Anita", Phone = "530-1459"]
})
}