Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.SplitColumn

Owen Duncan|Last Updated: 4/19/2018

About

Returns a new set of columns from a single column applying a splitter function to each value.

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

Arguments

ArgumentDescription
tableThe Table to modify.
sourceColumnThe column to modify.
splitter
columnNamesOrNumberList of column names that do not conflict with columns from the target table.
optional defaultDefault value.
extraValuesHandles of extra values or overflow values.

Example

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 = "Ringo", Phone = "232-1550"]  

})  

in  

    Table.SplitColumn(Customers,"Name",Splitter.SplitTextByDelimiter("i"),2)  
CustomerIDName.1Name.2Phone
1Bob123-4567
2Jm987-6543
3Paul543-7890
4Rngo232-1550
© 2018 Microsoft