Table.ExpandRecordColumn
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" })
Last modified 4yr ago