Dear all
I have another problem with Power Query , to combine files (with different column) in a folder.
See the attached files,
I have April & May files in One folder, and want to combine them into the April_May file.
However, error occurs , i try many times but still invain.
If i have them in one sheet, get data from tables, it is fine
Any help would appreciated
Eric
What error?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Aligw
How are you, hope this message find you healthy and strong against the COVID19
have two files
April file - column are
Date
PIC
Sales
May file - column are
Date
PIC
Product
When i get data to combine these two files in a folder, it prompts
[Expression.Error] The key didn't match any rows in the tables
An error occurred in the ‘Transform File (3)’ query. Expression.Error: The key didn't match any rows in the table.
Details:
Key=
Item=April
Kind=Sheet
Table=[Table]
How would i fix it
eric
Are you trying to merge the queries? If so, then if you have no matching data, there will be nothing to merge. Perhaps you should be appending?
Aligw
I am trying to append them, but as there is different columns.
So it prompt Error
Eric
It should cope. I’m away from my Pc, so can’t look at your files until tomorrow.
I did a simple append with the following results. I loaded each table individually and did not have PQ do it from a folder.
Data Range
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Dear alan
Thanks,
when i did it individually with table. it is fine.
As i want to try to do it from a folder, as user may place their files in a folder each month.
Is that a way ?
eric
Beyond my knowledge. Hopefully, Ali will have an answer after this weekend.
Open Power Query/Get and Transform. Click on New Query.
Open blank query in the editor, launch Advanced Editor and paste in the following code.
Change folder location in Red
Please Login or Register to view this content.
Last edited by Bo_Ry; 04-12-2020 at 05:51 AM. Reason: Shorten Code
Ive found this solution in many places, but what can i do if it doesnt appear Kind "Table" (only Kind "Sheet")?Originally Posted by Bo_Ry
Open Power Query/Get and Transform. Click on New Query.
Open blank query in the editor, launch Advanced Editor and paste in the following code.
Change folder location in Red
Please Login or Register to view this content.
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks