Power Query
Search…
published
Table
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"] })
Copy link
On this page
Table.SplitColumn
Description
Category
Examples