Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Expand Columns for Table with Unknown Column Names

I seached Google for "power query expand all columns". Top search result is from 2014 and seemed really complex, second item found did not seem simpler and only 3rd result was from this forum, by Im...
Show and Tell
Tips and Tricks
Aidan43's avatar
Aidan43
New Member
1 year ago

The equivalent for expanding records within records (see screenshot) is the following:

 

 

= Table.ExpandRecordColumn(
    #"Expanded output_data", 
    "output_data", 
    Record.FieldNames(
        Record.Combine(
            #"Expanded output_data"[output_data]
        )
    ), 
    Record.FieldNames(
        Record.Combine(
            #"Expanded output_data"[output_data]
        )
    )
)