Forum Discussion
Losing data from PowerQuery Merge
Hello,
I've managed to combine the data from two of my sheets. My second sheet get updated on a daily basis and what it does is changing some statuses in my Query sheet. However, when a row is deleted from the second sheet, the last updated information is also gone. How may I prevent this from happening? I need it to stay with the latest information (or if needed when I manually add some information, which is no longer available in the second sheet it should not be overwrited and placed as blank cell).
Thank you,
Alex
SaintEnt Okay! So you get an updated file every day and it happens that some orders no longer appear. Perhaps you need to apply a few extra steps to create a "new first" table. Tried to demonstrate it in the attached sheet. Perhaps a real PQ expert has a better idea.
14 Replies
SaintEnt PQ can indeed combine data that exists in multiple tables. When you delete a row from one table, then it will no longer be included in the combined data. What else do you expect? Perhaps I misunderstood. If so, can you upload a sample of your data and the query you created?
I believe you got the idea. It's to update status of an order (so I can't actually provide the sheets).
So is there any way to be able to use power query to update the sheet, without losing data if the sheet I'm getting the newest information does not have the old info? Tried with different kind of merging, however, all unsuccessful.
SaintEnt Okay! So you get an updated file every day and it happens that some orders no longer appear. Perhaps you need to apply a few extra steps to create a "new first" table. Tried to demonstrate it in the attached sheet. Perhaps a real PQ expert has a better idea.
