Forum Discussion
Solved
Distinct values based on multiple columns
I need to find distinct values in a table based on 3 columns. Example of data would be: PATNUM SCHDT SCHTM 123456 71317 08:00:...
If it helps, it SUPER easy to do what you are asking in reverse... You can select all 3 columns, then click 'Group By' and create a new Count Rows column. Now the count will be 2 for 123456 and 1 for everyone else? (Meaning that grouping of 3 data columns had 2 occurences, where the rest only had 1 distinct occurance of hte 3 columns.)
Hope this helps a little...
FOrrest
