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

Table.CombineColumns

Owen Duncan|Last Updated: 4/19/2018

About

The inverse of Table.SplitColumns, Table.CombineColumns merge columns using a combiner function to produce a new column.

Table.CombineColumns(table as table, sourceColumns as list, combiner as function, column as text) as table  

Arguments

ArgumentDescription
tableThe Table to modify.
sourceColumnsThe list of columns to combine.
combinerThe table combiner function.
columnThe column to modify.

Example

Table.CombineColumns(Table.FromRecords(  

{  

[A.1 = "a", A.2 = "b", B = "c" ],  

[A.1 = "b", A.2 = "c", B = "d"]},  

{"A.1","A.2","B"}),{"A.1", "A.2"},Combiner.CombineTextByDelimiter(","),"Merged")  
MergedB
a,bc
b,cd
© 2018 Microsoft