October 19, 2018
Hello - I am very new to PQ so apologies if this is a very basic question. I am attempting to merge data from two tables, one used for actual time spent and another for budgeted time using the task as the link between the tables. I am running into the following situation:
Actual Hours (Table 1):
Task A - Assistant - 15 hours
Budgeted Hours (Table 2):
Task A - Assistant - 20 hours
Task A - Manager - 30 hours
Task A - Director - 5 hours
Task A - Assistant 15 hours (Actual) and 20 hours (budgeted)
Task A - Assistant 15 hours (Actual) and 30 hours (budgeted)
Task A - Assistant 15 hours (Actual) and 5 hours (Budgeted)
So as you can see my actuals are being duplicated for each different position that was budgeted on a given task when only one instance of the actuals is correct.
Thank you for any help.
October 18, 2018
July 16, 2010
As Alan said, it makes it much clearer, quicker and easier if you can attach a sample file. Thankfully your example was relatively easy and I had a few spare minutes so I created a mock up Excel file for you.
In the attached file you'll see in the 'Source' step of the 'merge1' query that I selected the two 'Task' columns and then selected the two 'Role' columns to match. Hold CTRL to select multiple columns. You'll see Power Query has a 1 and 2 notation on the column headers.
Hope that points you in the right direction.