Forum Discussion

FCD's avatar
FCD
Regular Visitor
2 years ago

Moving a column at a specific place (column B) without Permutation

Dear All,

How to move a column at a specific place. i.e. after a column called Id.

I just don’t want to move it beacuse the quantity and the names of the columns before are variable in my code.

 

Thank you for your help.

Best Regards

Need Help

2 Replies

  • AlienSx's avatar
    AlienSx
    Icon for Super User rankSuper User
    2 years ago

    Table.ReorderColumns(tbl, {"called Id", "column_name"})

    but wait.. "I just don't want to move it..." at the same time sounds strange

  • FCD's avatar
    FCD
    Regular Visitor
    2 years ago

    I meant I did not want to drag and drop my column because the advanced Editor write the code like

    Table.ReorderColumns(#"RenamedCol",{"Id", "MovedColName", "C1", "C2", "C3", "...", "Cn"})

    The quantity and the names of columns C1 to Cn are variable according to a combination.

    That's why I wish I could place the column MovedColName at a second position indepndant from C1, C2, etc.

    Thank you for your help.