Forum Discussion
Remove 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.
Hello,
Stephen Tao is asking you to clarify what happens to the data after the 'Remove duplicates' step. Is it the same? The pictures shown above have the focus on the "Expanded.." step so we're seeing it before duplicates have been removed.
-------
My question is related but different. What rows do you think are duplicated from the picture because I don't see many. Also, are there any other columns that are not visible?
Ah. Got it. Yes, it looks the same.
To answer your question, in my images, of the 14 rows displyed, only 9 & 10 are not duplicated. So, 1-2 are duplicates, 3-4 are duplicates, 5-6, are duplicates, 7-8 are duplicates, 11-12 are duplicates, and 13-14 are duplicates. Am I missing something that suggests thos are not duplicates?
There are two columns not displyaed - 99204 Freq and 99205 Freq.