Hello. So I need help regarding combining excel files. I think I've got the hang of using power query after much trial & error. (I still don't fully understand it but the important thing is I seem to be able to get the output that I'm looking for... so far)
So recently, I tried to combine excel files using power query, but I kept getting the error that says, "key that didn't match any rows in the table".
Basically, all the excel files I intend to merge SHOULD have the same template, but in this case, I think some have changed.
So I trialed about three files with power query which seems like the template should be about the same, and those seem to work.. which is great! But now the problem arises with the other files where the template has changed.
So my question is.. is there a way I can Combine and Transform Data even if some of the other file templates have changed? As of right now, it would seem I have to manually check the files one by one that has changed. So once I've checked one by one only then I can properly use Power Query.. which will be too tedious...
So recently, I tried to combine excel files using power query, but I kept getting the error that says, "key that didn't match any rows in the table".
Basically, all the excel files I intend to merge SHOULD have the same template, but in this case, I think some have changed.
So I trialed about three files with power query which seems like the template should be about the same, and those seem to work.. which is great! But now the problem arises with the other files where the template has changed.
So my question is.. is there a way I can Combine and Transform Data even if some of the other file templates have changed? As of right now, it would seem I have to manually check the files one by one that has changed. So once I've checked one by one only then I can properly use Power Query.. which will be too tedious...