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... ;-)
Thanks for this - I ran into the same thing and couldnt figure out why. The table had a space after the last letter of the column name. All fixed!
Don't beat yourself up too badly. I'd been trying to figure this out for a few hours and your post put me on the road to a sloution. I have no idea where the extra spaces originate but the result is a rather annoying and time consuming piece of debugging. Thanks again.
Thank you, your post saved me from giving up.
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!
