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 | Opens the Data Quality Rules Panel |
Icon 4 | Parameters | Opens Manage Parameters Dialog |
Icon 5 | Samples | Opens Sampling Panel |
Run | 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
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.