Table.SplitColumn

 

This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.

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  

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.
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
Show: