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. ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    try this

     

     

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

     

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