Recent Addins ADO Application Arrays Charts Commandbars Count Dates Dialogs Events File access Files & Folders Functions Games Help Import & Export Lookup Off topic Other Outlook PivotTables Power Query Printing Problem solving Read me Searching Sorting Sound Strings Sum Time VBA programming VBE Workbooks Worksheets

Delete column if it exists (Power Query)

 2022-07-29    Power Query    0    241

Open the query in the Advanced Editor and add this line to delete a column if it exists:
#"Remove Column ColumnNameToDelete" = try Table.RemoveColumns(#"PreviousStepRef",{"ColumnNameToDelete"}) otherwise #"PreviousStepRef",