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" })