Thank you for your reply, Ziad.
Due to the sensitivity of the work, I unfortunately am not able to show the actual data, but I created this sample data in excel and will be able to better illustrate what I am trying to accomplish.
In the data set below, I would like to be able to compare the data B rows by the data A rows. (Maybe by using an SQL Minus command in my expression? SELECT * FROM A MINUS SELECT * FROM B UNION ALL SELECT * FROM B MINUS SELECT * FROM A? Just a thought)
I just want to be able to identify which records are being added or changed. So if I were to already have the A data, and I refresh the next week and B data is added, I will be able to easily identify which existing records are being changed as well as which new records are being added to my data chart. As an example, in the B records, I restated Pat_ID 1 and 3. As seen below, The Service_Type as well as Price for PAT_ID 1 and 3 changed from the A data. Because of this change, PAT_ID 1 and 3 get restated in my data set even though it is the same PAT_ID so when I search by PAT_ID, 2 records show up instead of just one updated record. When I refresh my dashboard, I would like to be able to have tab called 'Restatements" and every time I refresh my data, all of the Patient IDs with restated record will now show up on a chart so that I can identify and contact the people I need to contact to report the restated records and then eventually make the changes to that Patient's record on file.
I hope this better explains what I am trying to accomplish. Thank you for your input.
|IDENTIFIER||Date||Pat_ID||Service_Type||Price||# of records|