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.