Hi everyone,

I have an inventory watchlist report built using microsoft query to our sql database.

When I refresh the data query, the products duplicate and old data is saved.


For example product (123) has 0 on hand and 20 on work orders as of (6/21/2022)

When I refresh the connection today, a new row is added for the same product (123) but with updated inventory - ex: 10 on hand 10 on work orders.


That leaves me with duplicate rows in excel, which confuses my lookup functions in other sheets.

Does anyone know how to remove old data and update the excel table to new data without duplicating a product in a new row?