Forum Discussion
Solved
Merging tables query
I have below 2 tables-SO and SO_lines I want the output table as such that the new table should only contain those SO that are in SO table and the quantity column should be the the sum of only quant...
Assuming your relatioship is like this
Create a table as
Add filter
Your output will be
Assuming your relatioship is like this
Create a table as
Add filter
Your output will be
sevenhills how can I do the same in Power query?
For Power Query,
a) Using Merge Queries - inner join type
a) 1) Check this link https://docs.microsoft.com/en-us/power-query/merge-queries-innera) 2) As per the link, your right table for merge is "Table SO"
a) 3) Join Kind is Inner Join
a) 4) You dont need to expand for any right table columns
a) 5) remove unwanted columns
b) Select the column "item" , click group by Quantity
https://docs.microsoft.com/en-us/power-query/group-by