Forum Discussion
Solved
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 de...
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.
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?