Table.ExpandListColumn
Given a column of lists in a table, create a copy of a row for each value in its list.
function (tableas table,columnas text) as table
Given a
table, where a column is a list of values, splits the list into a row for each value. Values in the other columns are duplicated in each new row created.Table.Transformation
Split the list column [Name] in the table.
Table.ExpandListColumn(Table.FromRecords({[Name= {"Bob", "Jim", "Paul"}, Discount = .15]}), "Name")
Table.FromRecords({[Name="Bob", Discount=0.15],[Name="Jim", Discount=0.15],[Name="Paul", Discount=0.15]})
Last modified 4yr ago