Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to structure an exclusion array?

Hello

 

Is it possible to structure an array of all values excluding specific values?

 

I.e. I want to do Table.SelectColumns(#Table,not {"col1","col2"})

i.e. to select all columns of the model apart from specific columns.

 

Thanks!

Need Help
  • AntonioM's avatar
    AntonioM
    4 years ago

    I think you could combine Table.ColumnNames and List.RemoveItems

    Something like

     

    Table.SelectColumns(#Table, List.RemoveItems(Table.ColumnNames(#Table), {"Col1", "Col2}))

     

     

1 Reply

  • AntonioM's avatar
    AntonioM
    Solution Sage
    4 years ago

    I think you could combine Table.ColumnNames and List.RemoveItems

    Something like

     

    Table.SelectColumns(#Table, List.RemoveItems(Table.ColumnNames(#Table), {"Col1", "Col2}))