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   

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",


Leave a comment:

Your comment will only be published after it has been moderated and found spam free.
Your e-mail address will only be used to display your Gravatar.