Select more than one record to enable the Compare option within the table’s pop-up menu. This will open a compare table within the Console panel.
You can also view a compare table in the main workspace by using the ‘Compare’ command in a jKQL query line, for example:
jKQL > <Compare Activity where ActivityID in (‘activity ID of first selected activity', 'activity ID of second selected activity') show as comparetable>
In the Compare column the items to compare are displayed in alphabetical order. Change the order by clicking the sort buttons, (ascending) or (descending). This same function is available in all other columns.
The green column with Master located in the column header signifies the master record. All other selected records will display in blue and will be compared to the master record. To change the master record, simply click the Master to Compare button within any of the other blue columns. The column will move to the first position and will change to green. All other fields will now be compared against this new master.
In the Difference column, the + and - symbols signify whether there is a difference. If the difference can be measured mathematically, the numeric value will be displayed (for example, the microsecond difference of elapsed time).
To change the width of the columns, hover over the lines between column headers until you see the size icon ←‖→. Move it left or right to adjust column width.
The viewlet can be updated to display only rows with differences. Click the Viewlet Menu button and select Edit Viewlet. Enable the Only Show Differences option on the form. Only rows in which the data is different will now display.