Forum Discussion
Append Query duplicates some columns
Oh my word...!!!
So, before I basj myself over the head, let me share my mistake with you...
The issue was quite definitely different column names - there were some trailing spaces in the names of the 4 columns in my 2nd table. I had however checked for this earlier, within Excel, using a pattern match to identify any spelling differences, howeve it appears that the Excel pattern match excluded trailing spaces, and thus did not alert me to the fact that the column names were in fact not the same.
Ah well, thanks for listening... ;-)
Oh my word...!!!
So, before I basj myself over the head, let me share my mistake with you...
The issue was quite definitely different column names - there were some trailing spaces in the names of the 4 columns in my 2nd table. I had however checked for this earlier, within Excel, using a pattern match to identify any spelling differences, howeve it appears that the Excel pattern match excluded trailing spaces, and thus did not alert me to the fact that the column names were in fact not the same.
Ah well, thanks for listening... ;-)
Thank you for posting! 8 years on still useful. In my case, an accent had sneaked into one of my column headers, revealed by the PowerQuery step where the custom column had been created!