Forum Discussion
Solved
table.ExpanTableColumn with changing columns' names
hi there, Every month I get a brunch of 20 xls files containing 12+ columns. The name of those columns changed every month (typically previous 5 months, current month, next 6 months ) . How can I us...
Hello fsim
use this codesnippet to understand how to build your Table.ExpandColumn dynamically.
ExpandAllColumns = Table.ExpandTableColumn
(
PreviousStep,
"ColumnToBeExpanded",
List.Union
(
List.Transform
(
List.Buffer(PreviousStep[ColumnToBeExpanded]), each Table.ColumnNames
(
_
)
)
)
)
in
ExpandAllColumns
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy
