Table.SplitColumnTable.SplitColumn

SyntaxSyntax

Table.SplitColumn(table as table, sourceColumn as text, splitter as function, optional columnNamesOrNumber as any, optional default as any, optional extraColumns as any) as table

InfoAbout

Teilt die angegebenen Spalten unter Verwendung der angegebenen Aufteilungsfunktion in eine Gruppe zusätzlicher Spalten auf.Splits the specified columns into a set of additional columns using the specified splitter function.

Beispiel 1Example 1

Aufteilen der Spalte [Name] in zwei Spalten an der Position "i".Split the [Name] column at position of "i" into two columns

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"]
    })
in
    Table.SplitColumn(Customers, "Name", Splitter.SplitTextByDelimiter("i"), 2
CustomerIDCustomerID Name.1Name.1 Name.2Name.2 PhonePhone
11 BerndBob 12 34 56 7123-4567
22 JJ mm 98 76 54 3987-6543
33 PaulPaul 54 37 89 0543-7890
44 CrCr stst 23 21 55 0232-1550