Table.ExpandRecordColumn

Table.ExpandRecordColumn
Expands a column of records into columns with each of the values.
function (table as table, column as text, fieldNames as list, optional newColumnNames as nullable list) as table
Description
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.     
Category
Table.Transformation
Examples
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" })

Table.ExpandListColumn

Table.ExpandTableColumn

Last modified 4yr ago