Hi friends
I have folder which includes many identical excel files. Their columns and structure are the same. But when i try to import and merge thise files, Power query does not imprt them and for some files it gives error (attaches the picture)
As a sample file I upload two excel files which one of them ok but another gives error. There you can see that they are same.An error occurred in the ‘Transform File from Excel Forum’ query. Expression.Error: The key didn't match any rows in the table. Details: Key=Record Table=Table
I could not understand the reason. Please help me. Thank you in advance
Bookmarks