Forum Discussion
Solved
Re-order column
Hi All, I am working on the data set in SQL which may change regularly. I would like to keep 2 columns always at the begining and doesn't matter for the rest. 1. "ID" 2. "Item" is there any wa...
=let col=Table.ColumnNames(PreviousStep) in Table.ReorderColumns(PreviousStep,List.Sort(col,{{each List.PositionOf({"Item","ID"},_),1},each List.PositionOf(col,_)}))
=let col=Table.ColumnNames(PreviousStep) in Table.ReorderColumns(PreviousStep,List.Sort(col,{{each List.PositionOf({"Item","ID"},_),1},each List.PositionOf(col,_)}))