Forum Discussion
Expand all Columns in a Table at once
I need to expand each one of these columns that each represents a file, but it will take forever to do that. Is there a way to expand all of these columns at once?
2 Replies
- dufoq3
Community Champion
Hi Anonymous, check this:
let TableA = #table({"4/4/24", "4/11/24", "4/18/24"}, { {#table({"A", "B"}, {{1,2}, {3,4}}), #table({"A", "B", "C"}, {{5,6,7}, {8,9,10}}), #table({"D", "E"}, {{15,16}, {17,18}})} }), Ad_Helper = Table.AddColumn(TableA, "Helper", each 1, Int64.Type), UnpivotedOtherColumns = Table.UnpivotOtherColumns(Ad_Helper, {"Helper"}, "Date", "Table"), Ad_ColNames = Table.AddColumn(UnpivotedOtherColumns, "ColNames", each Table.ColumnNames([Table]), type list), ExpandedTable = Table.ExpandTableColumn(Ad_ColNames, "Table", List.Distinct(List.Combine(Ad_ColNames[ColNames]))), RemovedColumns = Table.RemoveColumns(ExpandedTable,{"ColNames", "Helper"}), ChangedType = Table.TransformColumnTypes(RemovedColumns,{{"Date", type date}}, "en-US") in ChangedType
