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

Prerequisites

Before you read this reference, 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.

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.