Forum Discussion

gabreila's avatar
gabreila
Frequent Visitor
6 years ago
Solved

Keep columns

Hello,
I don't know English, sorry for the mistakes.
I need help with Power Query.
I have n-columns and I need to keep the first 2 columns and the last 3 columns, the column names are different.

Thank you.

Gabriela

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    try this

     

     

        tabClean=Table.SelectColumns(tab,List.RemoveLastN(List.RemoveFirstN(Table.ColumnNames(tab),3),2))

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    try this

     

     

        tabClean=Table.SelectColumns(tab,List.RemoveLastN(List.RemoveFirstN(Table.ColumnNames(tab),3),2))

     

    • gabreila's avatar
      gabreila
      Frequent Visitor
      6 years ago

      Super, thank you. It was very difficult for me.

      Gabriela