Table.Split
The function divides a single table into multiple tables. The first table in the list includes the first set of rows equal to the specified page size. The following tables in the list contain subseque...
The function divides a single table into multiple tables. The first table in the list includes the first set of rows equal to the specified page size. The following tables in the list contain subsequent sets of rows according to the page size.
Divide a table containing five records into separate tables, each containing two records.
Power Query function used:
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 Power Query, the operation to split the table into multiple tables with two records each:
Table.Split(Customers, 2)
Output:
Table 1: Contains records for Bob and Jim
Table 2: Contains records for Paul and Cristina
Table 3: Contains record for Anita