How to merge two tables with the missing value repeating each time when not found

Question

Hello everyone&nbsp;&nbsp;Could you please help me&nbsp; with one power query question I struggle with: what is the optimal way to fully merge two tables for a case like this?&nbsp;&nbsp;&nbsp;&nbsp;For instance, when I use full outer merge, Product B will appear only once at the bottom of the merged table, not several times for each store as I would need it&nbsp;&nbsp;

wdx223_daniel · Answer

you can merge these two table the key of Product.

bi-ter · Answer

Thanks for your reply&nbsp;Though when I use merge by the key of Product the result I get is something like:&nbsp;&nbsp;and what I cant figure out is what is the way to achieve this kind of merge (= query to make merges for each store separately, not just aggregated)&nbsp;&nbsp;

Forum Discussion

How to merge two tables with the missing value repeating each time when not found

2 Replies

Related content

Insert row for missing repeating sequence in a table

Missing Table from LakeHouse

Insert row for missing repeating sequence in a table

Repeat data for the missing date

Paginated Report headers not repeating