Previewing transformations#
This guide explains how to preview your transformation instructions on collected data.
Introduction#
When configuring a transformation, you can preview the result of the instructions using the Preview tab. The preview displays the changes made to your data extract by the transformations.
Prerequisites#
Before you read this guide, perform all of the following actions:
Ensure the datastream to which the transformation is applied has at least one successfully fetched data extract.
The data extract contains the relevant values to be previewed during the transformation configuration.
Previewing the transformation output#
To preview the output of transformation instructions, follow these steps:
Go to the Transformations page.
Click the transformation you want to preview.
You can see the transformation preview in the Preview tab. The columns affected by the transformation are displayed in blue.
(Optional) If the transformation is assigned to multiple datastreams, in Preview datastream, select the datastream which latest data extract you want to use in the preview.
(Optional) Select the Only show affected columns checkbox to display only the columns affected by the transformation instructions.
Managing and previewing all transformations assigned to a datastream#
To manage and preview all transformations assigned to a datastream, follow these steps:
Go to the Datastreams page.
In the Transform subsection of the datastream overview, click + Manage transformations.
The page shows all transformations assigned to the datastream and the final data preview for all enabled transformations.
(Optional) Select the Only show affected columns checkbox to display only the columns affected by the transformation instructions.
You can perform the following actions on the Manage transformations page:
Note
All changes are saved automatically.
- Reorder
Drag and drop the transformations to set a new order.
- Disable
Disable the toggle next to a transformation to disable it for the datastream. Disabled transformations are excluded from the preview and are not applied during a fetch.
- Unassign
Click
Unassign to remove the transformation from the datastream.
- Clone
Click
Clone to create a new cloned transformation and assign it to the datastream.
- Edit a transformation
To edit an assigned transformation, follow these steps:
- Create or assign a new transformation
Click + Create new transformation or + Assign transformation to add more transformations to the datastream.
Troubleshooting#
Adverity may not display the preview for one of the following reasons:
There is an error in the transformation instructions.
There are no successful data extracts for the datastream for which the transformation is being created.
There are no appropriate values in the data extract. For example, if there are no numerical values in the data extract, then a currency conversion transformation has nothing to convert.