Forum Discussion
Manually enter data in rows of excel table using Power Query
The idea as in attached. But it depends on data logic. How to create the key and how to keep sorting depends on that.
I have tried using the internet and doing some experiments myself to find help but only found solutions for manually added columns as you mentioned. I would really appreciate your help with finding a solution for manually added rows.
Thank you.
The idea as in attached. But it depends on data logic. How to create the key and how to keep sorting depends on that.
- SergeiBaklan
Could you please explain how is the query "Source_1" created?
Because as far as I understood, the data source for query "Source_1" is the resultant table of the query "Source". However "Source_1" is being used in the creation of query "Source". It's kind of like an interconnected loop which I am not able to understand.
I would be really grateful if you could you please help me out with this.First, you create Source on any data and load result to the grid.
Second, you query that result, that will be Source_1
Third, you open Source again and modify it using Source_1. With that manually added data combined with the data queried from initial source.
Than you so much for the help!
Although I have some questions, I went through the solution and didn't understand the purpose of the two excel tables. Could you please elaborate a bit on the solution? I would really appreciate it, you've been a life saver.
First table is data source. That could be something else - external file, SQL, whatever. Actually we need only second table. Power Query returns data external source into it, that's what we do on first step. After that query returned table again and combine with initial query.
If the first table ("Source") is the data source, how is it referencing the second table ("Source_1") in its query to load "Source_1".
Can you help me understand the timeline of creation of the two tables. Which table is loaded first and then which query runs on which table?
Sorry if this is a silly question, but I'm a beginner in Power Query and I'm not able to understand.