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-
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
Shows the type of Sample currently displayed
The right section of the Transformer Bar contains the following-
Opens Search Panel to search transformations
Displays the Recipe Panel
Data Quality Rules
Opens the Data Quality Rules Panel
Opens Manage Parameters Dialog
Opens Sampling Panel
Run Job button
Opens the Run Jobs page
Learn more about the Recipe Navigator here.
For more details, read this documentation guide about the Transformer Bar
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
Eye icon - Click the eye icon to Edit Visible columns
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.
Learn more about the Transformer by reading this detailed documentation guide.