I have a dataset that runs daily through a workflow that gives me an output that we will call Output B. I need to add the following items:
1. I want to compare Output B from 10/13 to Output B from 10/12. It's the same columns but values in certain columns can change. I'd like to highlight any changes in value in the color blue. I'm looking to see the changes in one column only.
2. I want to see any new rows of data that were added to Output B, highlight in blue. So the difference from the two dates, a new row of data sometimes is added.
I've tried the compare data tool but it splits out changes, data added and data removed into separate columns and it doesn't include the rest of the data from the output. I'd like for all of the highlighted changes and highlighted new rows of data to appear on one tab, including the remainder of the dataset.