Forum Discussion
Column mismatch
Hello good people, I was trying to append 4 excel files and this is where I've landed. I can ammend this by editing the source file. But what happens when there are lots of files and editing so...
Anik Seems like you would have to use Table.FirstValue https://docs.microsoft.com/en-us/powerquery-m/table-firstvalue prior to append step that, depending on the outcome renamed the columns in question. Then, with the renamed columns, they will append into the correct columns.