See changes from a transform

<< Click to Display Table of Contents >>

Navigation:  How do I? >

See changes from a transform

The following transforms allow you to highlight changes made by the transform:

Case

Chop

Date Format

Decode

Extract

Fill

Hash

Insert

Number Format

Offset

Pad

Replace

Scale

Unfill

Units

Whitespace

 

Check the compare changes checkbox below the data table to highlight changes made by the transform.

 

See transform changes

 

Click on or hover over a cell to see details of each change.

 

Click on the up and down arrows to move between changes. Changes hidden by dataset filtering are skipped.

 

If you want to see rows that were removed by a transform such as Dedupe, Unique or Filter, you can do that using Subtract. The dataset needs to have a column of unique key values to use in the Subtract. If it doesn't have one, then add one first using Row Num.

 

show differences after Dedupe