Forum Discussion
Summing (SUMIFS) with a Pivot Table and Manual Table. Easier Method?
I would suggest you spend a few minutes reading https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_2010/power-query-get-transform-merge-join-append/83252b4a-785d-4e10-91dd-c887df283a65?tm=1589777580246 as nowhere in what I shared there's a merge between the 2 tables/queries, hence your questions
Assuming you used the same tables names in Excel (RawData & Inputs)
And you can select Inputs as First table and RawData as Second table, that doesn't matter in this scenario
1) Do I make the merge as new or append as new? Which one?
2) Did you merge/append the raw data to the input or vice versa? I did both ways (after cleaning and matching columns) and only pulls the data in that table.
3) What was the primary key/foreign key? I chose company and didn't get what I needed.
4) What type of join? I did default Left Join.
Other than making the merge queries that's all I need.
Thank you.
I would suggest you spend a few minutes reading https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_2010/power-query-get-transform-merge-join-append/83252b4a-785d-4e10-91dd-c887df283a65?tm=1589777580246 as nowhere in what I shared there's a merge between the 2 tables/queries, hence your questions
Assuming you used the same tables names in Excel (RawData & Inputs)
And you can select Inputs as First table and RawData as Second table, that doesn't matter in this scenario
- Glad I could help + Thanks for posting back
And don't apologize, we all started from scratch
Nice day... Thank you for the assistance. And thank you for providing me the details. I will go through this is detail.
Thank you for all the help. This fixed it. I apologize for my ignorance and thank you for showing me and you patience.