Forum Discussion
DanFromMontreal
Helper IV
Helper IVReordering column using a use define table
Hello dear Power query community, When I'm importing data from a CSV file and my 6 column header name are sequenced as shown in E3:J3 My final output should be like E5:J5 I have rearrange my colu...
Yes, that column is redundant. Use this.
= Table.ReorderColumns(Source,List.Select(tblHeaderSequence[Header], (i)=> List.Contains(Table.ColumnNames(Source),i))&List.Difference(Table.ColumnNames(Source),tblHeaderSequence[Header]))Great stuff.
Simple and to the point.
Many thanks
Vijay_A_Verma
Most Valuable Professional
Most Valuable ProfessionalYes, that column is redundant. Use this.
= Table.ReorderColumns(Source,List.Select(tblHeaderSequence[Header], (i)=> List.Contains(Table.ColumnNames(Source),i))&List.Difference(Table.ColumnNames(Source),tblHeaderSequence[Header]))
DanFromMontrealHelper IV
Helper IVGreat stuff.
Simple and to the point.
Many thanks