13 - Dealing with variable column names in Power Query (Excel)
I'm using "try [step] otherwise [last step]". This makes Power Query try the step. If this fails, the step will return the prior step.
Essentially, I'm saying "if you can find a column by this name, please change the name to something else. If you can't find this column, do nothing".
SAP loves randomly changing the names of your columns.
With this trick, you can make sure the names of your columns are constant, even if they're changed in your original data.