I have a fleet of files connected to sql databases. If we had redundant columns in the source we sometimes removed them using the power query "remove columns" feature. The gotcha is that if you later remove the columns from the source system, the query breaks because it cant find the columns to remove them. Syntax similar to the 'DROP column IF EXISTS' would be more resilient and easy to understand.
2 Comments
- select the columns you want to keep, then use the 'remove other columns' button.
- Status added:Needs Votes
