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 ...
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}))

     

     

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}))