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.
When I load your tables, I get the following Mcode. Don't see anything wrong here.
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.
let Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Account", type text}, {"Address", type text}, {"Amount", Int64.Type}}) in #"Changed Type"
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
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.
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?
For the example purpose, there are three workbooks, each containing one table, stored in one file on OneDrive.
Look at this video. Should be helpful.
https://www.youtube.com/watch?v=a7E29H5ZUmE
Thank you for your help. The video helped.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Baltimorejack68 
Register To Reply
Bookmarks