Show difference between two datasets in table

Hi All,

I'm having some difficulity with comparing two datasets. I have a set called Old Data and a set called New Data.

These sets both contain the exact same column names:

ID, Name, DateStart, DateFinish, Type, Setting

Both are Excel files, loaded in Spotfire. 

The ID, Name and DateStart columns will never change. But when I update the New Data file, it could be that DateFinish, Type or Setting is different from before like this:

Old Data:

ID Name DateStart DateFinish Type Setting
1 Smith 1-1-2018 5-5-2018 Rating 2

New Data:

ID Name DateStart DateFinish Type Setting
1 Smith 1-1-2018 6-6-2018 Rating 3

I want a table that shows something like this where bold and underlined values gets a colour:

ID Name DateStart DateFinish Type Setting
1 Smith 1-1-2018 6-6-2018 Rating 3

I really hope that I explained it correctly and that you have an idea of how I want to see thing. Appreciate every help, thanks!

 

(3) Answers

Login