Table.ExpandTableColumn

Table.ExpandTableColumn
Expands a column of records or a column of tables into multiple columns in the containing table.
function (table as table, column as text, columnNames as list, optional newColumnNames as nullable list) as table
Description
Expands tables in table[column] into multiple rows and columns. columnNames is used to select the columns to expand from the inner table. Specify newColumnNames to avoid conflicts between existing columns and new columns.
Category
Table.Transformation
Examples
Expand table columns in [a] in the table ({[t = {[a=1, b=2, c=3], [a=2,b=4,c=6]}, b = 2]}) into 3 columns [t.a], [t.b] and [t.c].
Table.ExpandTableColumn(Table.FromRecords({[t = Table.FromRecords({[a=1, b=2, c= 3],[a=2,b=4,c=6]}), b = 2]}), "t", {"a","b","c"}, {"t.a","t.b","t.c"})
Table.FromRecords({[t.a = 1, t.b = 2, t.c = 3, b = 2], [t.a = 2, t.b = 4, t.c = 6, b = 2]}, { "t.a", "t.b", "t.c", "b" })

Table.ExpandRecordColumn

Table.FillDown

Last modified 4yr ago