I would like to create a query that shows unmatched records. I am using two files. File one contains hospital name with a checkmark for eacf of 10 quality initiatives they are working on.
The second file is a data dump from the govt. It shows who entered data. I have a hopsital ID in both. The quality topics are listed in sepearate colums of the first file and in a single column in the second file.
I want to create a query to find out who is working on an initiative but has no data.
The second file is a data dump from the govt. It shows who entered data. I have a hopsital ID in both. The quality topics are listed in sepearate colums of the first file and in a single column in the second file.
I want to create a query to find out who is working on an initiative but has no data.
