Skip to main content
All CollectionsTransforming Data
Transformer UI Overview
Transformer UI Overview

Understand the Transformer View- menus, transform options, suggestions pane and visual data profiling information presented

Thea avatar
Written by Thea
Updated over 2 years ago

When working on cleaning and preparing your data with Trifacta, you will spend most of your time in the Transformer Grid, aka. Transformer Page.

The Transformer page has the following main sections-

A. Transformer Bar

The Transformer Bar is the top most section of the Transformer Page that contains menus that are different from the standard Trifacta menu bar.

The left section of the Transformer Bar displays the following-

Flow Name

Displays name of the Flow. Click on the link to go to Flow View

Recipe Name & Navigator

Shows the Recipe name & click on the arrow to navigate to other recipes in the flow

Sample Indicator

Shows the type of Sample currently displayed

The right section of the Transformer Bar contains the following-

Icon 1

Search Transformations

Opens Search Panel to search transformations

Icon 2

Recipe Icon

Displays the Recipe Panel

Icon 3

Data Quality Rules

Icon 4

Parameters

Icon 5

Samples

Run

Run Job button

Opens the Run Jobs page

Learn more about the Recipe Navigator here.

B. Transformer Toolbar

The Transformer Toolbar contains different Transform options and tools available within Trifacta.

At the top of the data grid and the column browser, the Transformer toolbar provides quick access to common transformations. When a tool is selected from one of the drop-downs in the toolbar, a new step is inserted into the current location in your recipe with some parameters pre-specified for you. You can then finish creating the transformation using the Transform Builder.

The toolbar also contains the options to switch between Grid view and Columns View of your data.

To learn more about Transformer toolbar icons individually, read this detailed documentation guide.

C. Data Grid

The grid is the default view in the Transformer page of Trifacta Wrangler.

The Data Grid displays the sample of the data from the dataset and will dynamically update when you add transformations. The data is presented in rows and columns , with the column name and inferred data type at the top of each column. For each column, there is also a Data Quality Bar and Histogram, which shows a profile of the values.

Click column headings to review a visual profile of the column's data and a set of suggestions for transformations to apply to the column.

To learn more about data grid panel, read this detailed documentation guide.

D. Grid Metadata Bar or Status Bar

Below the data grid, you can review summary information about the data in your currently selected sample in the Grid Metadata Bar, also known as the Status Bar.

The status bar contains metrics about the current dataset sample for the currently selected recipe step.

  • Number of columns

  • Number of Rows

  • Number of data types

  • Show/Hide data grid options - Click on the arrow to open the options

    • Edit visible columns - Show or hide the visible columns. For more information, see Visible Columns Panel.

    • Edit with data grid (on/off) - Here you can toggle updating of the data grid based on the changes to your recipe. When disabled, the data grid is frozen. You can also enable the data grid by using the reload icon available.

      This feature can be enabled or disabled by an administrator.

      For more information, see Dataprep Project Settings Page.

    • Show column histogram (on/off) - Here you can toggle the loading of column histograms on or off to improve transformer load time

To learn more about the status bar, read this detailed documentation guide.

E. Context Panel

On the right side of the Transformer page, the context panel displays one of multiple panels, depending on the current state or selection of the data grid.

Select any column by clicking on the column header - Column Details are displayed in the Details panel on the right side,

The Details panel shows

  • A brief preview of profiling information of the column regarding data quality like Data Quality bar, % of valid/missing or mis-matched values, Unique values etc.

  • Patterns identified by Trifacta based on the data in the column

  • Auto generated Suggestions for transformations that you can perform

For more information on Column Details, read this documentation article.

Click on the More(...) icon to open the Column Context Menu. You can select actions to perform on the column from this menu.

The following panels may be displayed within the context panel-

To close the context panel, click the X icon in the upper-right corner.

To learn more about the Context Panel, read this detailed documentation guide.

More Info

Learn more about the Transformer by reading this detailed documentation guide.

Did this answer your question?