Forum Discussion
cathoms
Responsive Resident
Responsive ResidentRemove duplicate rows from a new merged query
Hello! I have two Excel worksheets that I am trying to join into a single query/dataset and I am getting duplicate rows that I can't seem to remove. I've tried this is both Power Query Excel and Powe...
Let's take 13-14 as an example. There are different values for 'Total New Office Visits' and '99203 Freq' therefore the rows are not duplicates.
-------------
Other pairs also have differences.
Either :-
1 of the rows in each case is correct (in which case you need to figure out which one),
they're both wrong,
they're both right .
-----------
It's possible that the Merge Queries is wrong but I don't know your data so can't say.
cathomsResponsive Resident
Responsive ResidentWould it be better to keep the different time period data in separate source files, then merge them in Power Query?