Re-order column

[ngct1112]

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 way I could achieve that without inputting other column names in the query?

= Table.ReorderColumns(#previous_step,{"ID", "Item" ......})

Thanks!

[wdx223_Daniel · Accepted solution]

=let col=Table.ColumnNames(PreviousStep) in Table.ReorderColumns(PreviousStep,List.Sort(col,{{each List.PositionOf({"Item","ID"},_),1},each List.PositionOf(col,_)}))