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:

  1. Go to the Transformations page.

  2. Click the transformation you want to preview.

  3. You can see the transformation preview in the Preview tab. The columns affected by the transformation are displayed in blue.

  4. (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.

  5. (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:

  1. Go to the Datastreams page.

  2. Open the chosen datastream by clicking on its name.

  3. 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.

  4. (Optional) Select the Only show affected columns checkbox to display only the columns affected by the transformation instructions.

  5. 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 image1 Unassign to remove the transformation from the datastream.

    Clone

    Click image2 Clone to create a new cloned transformation and assign it to the datastream.

    Edit a transformation

    To edit an assigned transformation, follow these steps:

    1. Click on the transformation name.

    2. Change the transformation’s configuration.

    3. (Optional) Click Refresh preview image3.

    4. Click Save to save the changes.

    Create or assign a new transformation

    Click + Create new transformation or + Assign transformation to add more transformations to the datastream.

  6. Click Finish image4.

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.