Feature – Data Comparing

If it involves Data - we can help you

InSights Into Data has a very powerful Data Set Compare feature.  This allows the user to compare two in-memory data tables – showing the differences in a visual manner.  It can be very useful in understanding what has changed between two periods in time.  Very handy when verifying Data Sets for AI work!
The way it works is you first choose which two tables you want to compare.  Then populate the fields from those tables – and choose what field(s) you will compare the tables on – and what fields you want to compare with.  
In the example below – you can see that we have chosen the Order Id field to compare on (it is the unique key to both tables).  Then we have choses the Price and OrderAmt fields to use for Field level comparisons.  

Table and Field Selection

Row Level Comparison

The above screen capture shows the first view you will see when you hit the compare button.  It shows the results visually as to what rows have been added, deleted, or just changed.  The new rows are colour coded in light Orange, the deleted rows are highlighted in a light blue, and finally the rows that have been changed are highlighted in a light purple.  These colours allow you to easily recognize how the data sets have changed over time.  It allows you to focus your attention to the changes that are important to you. 
Note the column “Row Status” shows the changes in a Text format (NEW, DEL, CHG).  As well – note the bottom left hand corner of the screen – here you can see that *ROW level comparison has been selected.  

Field Level Comparison

In the screen capture above – it shows a different view of the comparison data.  In this view – the user has chosen one of the Comparison fields selected on the previous screen – in the lower left hand corner.  In this example it is the Price field. 
Here you can see easily see which rows have had a Price increase or decrease.  In this case the rows for Milk and Choc Bar have seen price changes.
The original price is shown in the original fields on the left side of the grid, while the new prices and the changed amounts are shown on the right hand side.  

Let's have a chat

Learn how we can help you explore your data