Forum Discussion
PowerQuery remove Columns
Hi Guys is there an uncomplicated way to remove an "unknown number" of columns? for example, all what start with "column.01, column.02, column.03" and so on for example with column.0* 1. i ne...
You need to create list of columns to remove. That could be done by different ways and depends on logic in column names. As variant
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
columnsToRemove = List.Select( Table.ColumnNames(Source), each Text.StartsWith( _, "Column.0") ),
removeColumns = Table.RemoveColumns(Source, columnsToRemove)
in
removeColumns