Table.SplitAt
Table.SplitAt(table as table, count as number) as list
Returns a list containing two tables: a table with the first N rows of table
(as specified by count
) and a table containing the remaining rows of table
. If the tables of the resulting list are enumerated exactly once and in order, the function will enumerate table
only once.
Return the first two rows of the table and the remaining rows of the table.
Usage
Table.SplitAt(#table({"a", "b", "c"}, {{1, 2, 3}, {4, 5, 6}, {7, 8, 9}}), 2)
Output
{
#table({"a", "b", "c"}, {{1, 2, 3}, {4, 5, 6}}),
#table({"a", "b", "c"}, {{7, 8, 9}})
}