Hi All:
I am getting an error - An error occurred in the ‘Transform File’ query. Expression.Error: The key didn't match any rows in the table.
I know the cause which is the worksheet in each workbook has a different name.
Googled but fixes are beyond my understanding.
How do I fix this so I can combine 01Dec2020 with 01Jan2021 etc. Sheet names are same as workbook names.
No problem if sheets are in same workbook, but if in a folder, doesn't work.
Attached are screen shots and workbooks.
Thanks
Robb
Hi Robb,
Have you tried to use this technique to get multiple files from a folder that contain multiple sheets with Power Query?
Mynda
HI Mynda:
I did. the Excel.Workbook ([Content]) M code did not work for some reason. I got error for all Binaries.
I take it that this should solve the issue of different sheet names in workbooks in folder?
I'll try again, and see what happens, and send screen shot.
Thanks
Robb
Hi Robb,
The example file you attached above uses the built in combine files function. The technique I linked to above works slightly differently and doesn't return errors for the binaries. I suggest you try following the steps in the tutorial, as I just tested it on your files and it worked for me.
Mynda
Hi Mynda: I see now. Works great,. The built in functions throw me off. Robb