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 |
| A | 1/1/2016 | 1 | a | $8 | 1 |
| A | 1/2/2016 | 2 | b | $7 | 1 |
| A | 1/4/2016 | 3 | c | $6 | 1 |
| A | 1/5/2016 | 4 | d | $5 | 1 |
| A | 1/5/2016 | 5 | e | $4 | 1 |
| B | 1/6/2016 | 6 | b | $8 | 1 |
| B | 1/7/2016 | 7 | c | $7 | 1 |
| B | 1/1/2016 | 1 | b | $5 | 1 |
| B | 1/4/2016 | 3 | a | $6 | 1 |
| B | 1/8/2016 | 8 | d | $4 | 1 |
