Expands a column of records into columns with each of the values.
function (
table
as table,column
as text,fieldNames
as list, optionalnewColumnNames
as nullable list) as table
Given the column
of records in the input table
, creates a table with a column for each field in the record. Optionally, newColumnNames
may be specified to ensure unique names for the columns in the new table.
Table.Transformation
Expand column [a] in the table ({[a = [aa = 1, bb = 2, cc = 3], b = 2]})
into 3 columns "aa", "bb" and "cc".
Table.ExpandRecordColumn(Table.FromRecords({[a = [aa = 1, bb = 2, cc = 3], b = 2]}), "a", {"aa", "bb", "cc"})
Table.FromRecords({[aa = 1, bb = 2, cc = 3, b = 2]}, { "aa", "bb", "cc", "b" })