Power Query - Expression Error: The Key didn't match any rows in the table

[Baltimorejack68]

I am trying to get data from a file using Power Query. The tables are named Table1, Table2, Table3. Each are simple small tables with matching headers; Account Address Amount

Key=
Item=Table1
Kind=Table
Table=Table

In the formula bar is the message: = #"Changed Type"{9}[Source.Name]

I get that PowerQuery is looking for something that is not there, but what is not there???

Any help would be appreciated. Thank you.

[alansidman]

When I load your tables, I get the following Mcode. Don't see anything wrong here.

Please Login or Register  to view this content.

Perhaps if you load your files along with the Power Query so we can see exactly what you are doing or trying to do. It would also help if you expanded on what you are trying to do specifically. Mind reading is not my forte.

[Baltimorejack68]

Thank you for your help. Attached is the third table and the Query showing the error. Here's what I would like to accomplish; I have several workbooks in a folder and I am trying to combine the data in the tables using the headers of the tables (Headers are the same for each table). The files attached are "dummy tables" and they are much smaller than the actual files I will be using once my error is solved. I"m somewhat new to Power Query. Thank you again for your help and patience. If you need more info, please let me know.

[alansidman]

You have provided three tables in three different files. In reality is this how the data is arranged or are the tables in one file with three different sheets?

[Baltimorejack68]

For the example purpose, there are three workbooks, each containing one table, stored in one file on OneDrive.

[alansidman]

Look at this video. Should be helpful.

https://www.youtube.com/watch?v=a7E29H5ZUmE

[Baltimorejack68]

Thank you for your help. The video helped.

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.