Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Dynamically delete column names

Hello everyone, I am trying to dynamically delete column names.    Background on my query: my source is linked to a sharepoint folder that contains multiple Excel sheets and I upload a new one ever...
Need Help
Tips and Tricks
parry2k's avatar
parry2k
Super User
2 years ago

Anonymous you can paste the following code and there is one step I added which will remove the budget columns dynamically.

 

 

let
    Source = Excel.Workbook(File.Contents("C:\Users\parvi\Downloads\Week 4 - sample file.xlsx"), null, true),
    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
    #"Table Remove Budget Columns" = Table.SelectColumns(#"Promoted Headers", List.RemoveMatchingItems(Table.ColumnNames(#"Promoted Headers"), List.Select(Table.ColumnNames(#"Promoted Headers"), each Text.Contains(_, "Budget"))))
in 
#"Table Remove Budget Columns"