Table.SplitColumn

Table.SplitColumn
Splits the specified columns into a set of additional columns using the specified splitter function.
function (table as table, sourceColumn as text, splitter as function, optional columnNamesOrNumber as nullable any, optional default as nullable any, optional extraColumns as nullable any) as table
Description
Splits the specified columns into a set of additional columns using the specified splitter function.
Category
Table.Transformation
Examples
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)
Table.FromRecords({ [CustomerID = 1, Name.1 = "Bob", Name.2 = null, Phone = "123-4567"], [CustomerID = 2, Name.1 = "J", Name.2 = "m", Phone = "987-6543"], [CustomerID = 3, Name.1 = "Paul", Name.2 = null, Phone = "543-7890"], [CustomerID = 4, Name.1 = "Cr", Name.2 = "st", Phone = "232-1550"] })

Table.Split

Table.ToColumns

Last modified 4yr ago