Forum Discussion
Responsive ResidentRemove duplicate rows from a new merged query
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.
Community ChampionLet'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.
- cathoms
Well I feel stupid...
Yep, I see the differences now - I was focusing on the duplication of the period and provider combination. Now I need to figure out why I'm getting those differences.
Thanks.
