Forum Discussion
Merge 2 tables with same column name and duplicated products
Imrans123 & jbwtp Thank you both for your help! I ended up appending and filling the gaps in Excel with a "if empty, fill down" function, which solved 80% of my gaps. Then manually filling the remaing gaps. 😞
Probably the ugliest process ever, but it was only 500 rows of data.
I don't know why I thought there was an easy-button for that LOL
Memorable MemberHi Cyclops1717,
If you do not have duplicates except where Price Range it set n one table, but not in another than Table.Combine those tbales and then filter off blanks in the Price Range field.
If you do have the duplicates, than still Table.Combine and than Table.Group applying your decision logic to the Price Range field (which can be as simple as List.Max).
P.S.
Sorry, just ralised that you may have gaps in the other fields too, except the Product field. In this case use the later approach, group by Product and use List.Max on other columns. I think this would still be quicker than merging tables and creating new/deleting redundant columns.
Cheers,
John
Helper IIIdoes this mean merging actually does work?
Could someone refer to this and tell me what's wrong with merging?
https://community.fabric.microsoft.com/t5/Desktop/The-sequence-of-events-to-create-the-final-table-does-not-make/td-p/3976187