Forum Discussion
Solved
Append and update data
I have a scenerio where i get updated list of Products, owner, version, Product Manager etc for the month. The list contains only the active products. I have to build analytics based both active and ...
You may try Append Queries (Table.Combine) in Query Editor and refer to the Power Query solution in this post.
Thanks TomMartens
or i could append data so that i have recent data on top and old month tables at bottom. Then i can simply remove duplicates. Since remove duplicate works from bottom to top, i will have older data removed and kept version updated version 1.03 and new products AA2 as it will not be duplicate.
You may try Append Queries (Table.Combine) in Query Editor and refer to the Power Query solution in this post.