Table.Split

Syntaxe

Table.Split(table as table, pageSize as number) as list

À propos

Divise table en une liste de tables dont le premier élément est une table contenant les pageSizepremières lignes de la table source, l’élément suivant de la liste est une table contenant les pageSizelignes suivantes de la table source, etc.

Exemple 1

Divise une table de cinq enregistrements en tables de deux enregistrements chacune.

Utilisation

Power Query M

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)

Sortie

Power Query M

{
    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"]
    })
}