Forum Discussion
Anonymous
4 years agoNot applicable
Remove multiple columns in Power Query
Hi, Is there a way to remove multiple columns in Power Query or do I need to remove one each time? Based on the above image, i'm checking if the column exists, and if it does, I want to re...
- 4 years ago
You can intersect the list of columns you want to remove with the existing column names like this:
= Table.RemoveColumns( RenamedColumns, List.Intersect( { Table.ColumnNames(RenamedColumns), {"UnitPrice", "TaxRate"} } ) )
wdx223_Daniel
Community Champion
4 years agoNewStep = Table.RemoveColumns(PreviousStepName,{the list of column names which you want to remove},2)