Compare datasets

<< Click to Display Table of Contents >>

Navigation:  How do I? >

Compare datasets

Comparing headers

To compare headers between 2 or more datasets:

Select 2 or more items in the Center pane

Select View>Compare Headers... , use the right click menu or Option+H.

 

Compare datset headers

 

Notes:

Set Compare headers by to compare by Column name or Column index (position).

Comparing by Column name is sensitive to case and whitespace.

Set Show to show All, Only matches or Only differences, depending on the rows you want displayed.

Differences are shown colored. Missing headers are shown hatched.

Click the color button to change the difference color.

 

Comparing data

To compare the data in 2 datasets:

Select 2 items in the Center pane

Select View>Compare Data..., use the right click menu or Option+D.

 

Compare data side-by-side

 

Notes:

Set Compare by to Row numbers to see a row-by-row comparison of the 2 datasets.

Set Compare by to Key columns to see a comparison by key values in each dataset.

oSet the Key column for left and right datasets.

oCheck Sort by key to sort the keys in ascending order.

oCheck case sensitive to make the key comparison case sensitive.

Differences are shown colored. Missing rows are shown hatched.

An overview of the differences by row are shown on the left. You can click or drag this overview to navigate.

Click Top to scroll to the top of both datasets.

Click Previous row difference to go the previous row with a difference.

Click Previous difference to go the previous cell with a difference.

Click Next difference to go the next cell with a difference.

Click Next row difference to go to the next row with a difference.

Click Bottom to scroll to the bottom of both datasets.

Click Swap to swap the left/right positions of the two datasets.

Check synchronize vertical scroll to make vertical scrolling in one pane mirrored in the other pane.

Check synchronize horizontal scroll to make horizontal scrolling in one pane mirrored in the other pane.

Click Differences to change the color used to highlight differences.

 

See also:

See changes from a transform