When you create or edit a transform, the data grid displays a preview of results of the transform. Transform previews assist in specifying and validating the transformation steps before they are applied. Although final results may not be exactly represented, a preview gives a good indication of the changes.
When you review a preview, keep the following in mind:
For example, you want to remove leading and trailing quotation marks from all columns. You highlight the quotation marks in one cell and select a suggestion card for Replace:
Replace Suggestion Card
To replace in all columns, you click the third option. To verify that it is correct for your needs, you click Edit.
The transform preview displays in the data grid for each column to be modified:
Tip: The preview also contains updated data quality bars and column histograms. So, you can cut and then paste the step again to see changes in these visual counts in the preview.
Transform Preview for Replace
The transform preview displays for all valid transforms.
When you modify the transform in the Transform Builder, the preview is updated as you type.
Preview color scheme:
|blurred||transform is invalid|
An error might appear while you are typing the transform. Because the transform is not valid, the transform preview appears blurred and does not display the results of the transform.
Previews vary depending on the type of transform. For example, if you create a transform to replace values in a column, the preview displays the results of that transform. If you create a transform to extract values from a column, the preview displays the values that will be extracted.
Split Pane Preview