Overwrite new data with keeping column headers

[Anonymous]

Hello,

I want to know if it is possible to change new data with keeping column headers untouchable.

I am gonna to clarify more

I have data for the month of june which I cleaned and worked on in power query and now i want to upload July data but I encoutred problemes of headers changes 006/2018 instead of 007/2018

 Thanks in advance

[ntaylo06 · Accepted solution]

In order to keep queries from breaking when the data in a file changes you have to avoid referencing columns by their promoted headers. It looks like you need to modify columns BEFORE you promote headers so that you are modifying 'Column 2' instead of '006/2018' because '006/2018' will not exist but 'Column 2' will.