Page tree

The cloud-based product Trifacta Free is available now! Register for your free account.

 

Use the links below to access the reference pages for the Trifacta application user interface.

Home

Item Description
Home Page From the Home page, you can create or access your flows, datasets, and jobs, as well as configure settings and find additional resources. See Home Page.
Flows Page The Flows page displays the flows to which you have access and lets you create, review, and manage them. flow is an object for bringing together and organizing the datasets, recipes, and other objects that you use to generate your results. See Flows Page.
Library Page In the Library page, you can review your imported and reference datasets and any macros that you may have created. You can also import new data from this page. See Library Page.
Jobs Page In the Jobs page, you can track the status of all of your jobs. See Jobs Page.
Transformer Page In the Transformer page, you identify the data that you need to transform and build your transformation recipes on samples taken from your currently selected dataset.  See Transformer Page.
Preferences Page From the Preferences page, you can manage aspects of your user account and other settings. Select Help menu > Preferences. See Preferences Page.

Flows

Flows Page

Item Description
Create Flow Page You can use flows to organize your datasets and to track the jobs associated with them. See Create Flow Page.
Flow View Page In Flow View, you can access and manage the objects that you have added to or created in the selected flow. You can perform a variety of actions to effectively manage flow development and job execution through a single page in the Trifacta® application. See Flow View Page.

Flow View

Flow View Page

Item Description
Change Dataset Dialog Through the Flow View page, you can change the source that is used for your dataset. In this manner, you can apply the same recipe across datasets with the same schema. When the source dataset has been changed, a new sample is automatically generated for you. See Change Dataset Dialog.
View for Imported Datasets When you select an imported dataset in Flow View, you can review its details in the context panel and select options from its context menu. See View for Imported Datasets.
View for Recipes For each recipe in Flow View, you can review or edit its steps or create new recipes altogether. You can also create references to the recipe, modify outputs, and create new recipes off of the recipe. See View for Recipes.
View for Reference Datasets reference dataset is a reference to a recipe's outputs that has been added to a flow other than the one where the recipe is located. When a reference dataset is selected, details are available in the context menu. See View for Reference Datasets.
View for References When you select a recipe, you can choose to create a reference object off of that recipe. From the recipe context menu, select Create Reference Dataset. See View for References.
View for Unstructured Datasets An unstructured dataset is an imported dataset that does not contain any initial parsing steps. All parsing steps must be added through recipes that are applied to the dataset. During the import process, you disable the initial steps that are applied to imported datasets. Instead, these steps are added as the first steps of the auto-generated recipe that appears with the dataset in Flow View. See View for Unstructured Datasets.
View for Outputs Associated with each recipe is one or more outputs. These publishing destinations can be configured through the context panel in Flow View. Through outputs, you can execute and track jobs for the related recipe. See View for Outputs.
Flow Search Panel You can search for objects within your flow. In Flow View, click the Magnifying Glass icon at the top of the page. See Flow Search Panel.

Library

Library Page

Item Description
Dataset Details Page Use the Dataset Details page to review a dataset's usage and to perform management tasks on it. See Dataset Details Page.
Import Data Page Through the Import Data page, you can upload datasets or select datasets from sources that are stored on connected datastores. From the Library page, click Import Data. See Import Data Page.
Macros Page In the Macros page, you can review and manage the macros to which you have access. See Macros Page.

Macros Page

Item Description
Macro Details Page Through the Macro Details Page, you can review details about an individual macro. In the Macros page, click the name of the macro to review. See Macro Details Page.

Jobs

Item Description
Job Details Page You can use the Job Details page to explore details about successful or failed jobs, including outputs, dependencies, and other metadata. Download results to your local desktop or, if enabled, explore a visual profile of the data in the results for further iteration on your recipe. See Job Details Page.

Transformer

Transformer Page

Item Description
Data Grid Panel The data grid in the Transformer Page displays how your current recipe applies to the data in your currently selected sample. See Data Grid Panel.
Recipe Navigator Through the Recipe Navigator, you can locate and open any recipe from the current flow in the Transformer page. To open the Recipe Navigator, select the drop-down next to the name of the current recipe in the Transformer page. See Recipe Navigator.
Transformer Toolbar At the top of the data grid and the column browser, the Transformer toolbar provides quick access to common transformations. See Transformer Toolbar.
Column Menus You can use the menus available in a column context menu to perform a variety of actions on the column or columns.  See Column Menus.
Column Browser Panel Through the Column Browser, you can use data quality bars and data type information to perform basic review of data across many columns. You can use these tools to select data of interest for display in the data grid or Column Details views or to prompt for suggestions of recipe steps. See Column Browser Panel.
Column Details Panel In the Column Details panel, you can review additional details about a column of your dataset. Select Column Details from any column menu or the Action menu in the column browser. See Column Details Panel.
Transform Preview When you create or edit a transform, the data grid displays a preview of results of the transform. Transform previews assist in specifying and validating the transformation steps before they are applied.  See Transform Preview.
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. See Context Panel.
Filter Panel As needed, you can filter the rows and columns displayed in the data grid. To review and apply filters, click the Filter icon in the Transformer toolbar.  See Filter Panel.
Visible Columns Panel In the status bar of the Transformer page, click the Eye icon to review the list of visible and hidden columns. See Visible Columns Panel.
Union Page In the Union page, you can append data from one or more datasets to an existing dataset. See Union Page.
Run Job Page In the Run Job page, you can specify transformation and profiling jobs for the currently loaded dataset. Available options include output formats and output destinations. See Run Job Page.

Data Grid Panel

Item Description
Column Histograms The bar chart at the top of each column in the Transformer page, called a histogram, characterizes the data in that column. Each column histogram displays the count of each detected value in the column (for string data) or the count of values within a numeric range (for number data). See Column Histograms.
Data Quality Bars Just below the column name in the data grid is a horizontal band, which identifies data quality issues among the sample values in the column. See Data Quality Bars.
Lookup Wizard Through the Transformer page, you can perform lookups from one set of values in your dataset into another set of values in another dataset using a simple wizard. To perform a lookup, select the caret next to a column title, and then select Lookup.... See Lookup Wizard.
Standardize Page Through the Standardize page, you can review similar column values and standardize them to values that you specify. See Standardize Page.

Column Menus

Item Description
Transformation by Example Page In the Transform by Example page, you can build new columns of data by specifying values to map from the selected source column. For the column to transform, select Create column by examples from the column menu. See Transformation by Example Page.
Choose Datetime Format Dialog In the Datetime Format dialog, you can specify or locate the format that you'd like to use for validation of the values in the current column against the Datetime data type.  See Choose Datetime Format Dialog.

Context Panel

Item Description
Recipe Panel   Through the Recipe panel, you can review and modify the steps of the recipe that you have already created and add new steps to your recipe at the current location. See Recipe Panel.
Search Panel Through the search context panel, you can locate transformations to specify and add at the current location in your recipe. See Search Panel.
Transform Builder The Transform Builder enables you to search for transformations and to rapidly assemble complete transform steps through a simple menu-driven interface.  See Transform Builder.
Selection Details Panel In the Selection Details panel, you can review an active profile of your current selection or selections in the data grid or column browser and review patterns and suggestions for transformations. See Selection Details Panel.
Samples Panel For smaller datasets, the Transformer page displays the entire dataset. For larger ones, the source data is sampled for use in the Transformer page. Through the Samples panel, you can create new samples and select them for display in the Transformer page. See Samples Panel.
Edit History Panel Through the Edit History panel, you can review the sequence of edits to the current recipe by individual contributors. This panel assists in determining who made which changes and when they were made. See Edit History Panel.
Join Window In the Join window of the Trifacta® application, you can join your current dataset with another dataset or recipe based upon information that is common to both datasets. See Join Window.


Preferences

Preferences Page

Item Description
User Profile Page In your user profile, you can reset your password and change other user settings. See User Profile Page.
Data Usage Page On the Data Usage page, you can review the data volumes that you have used during the current month for uploads, job execution, and sampling. See Data Usage Page.

This page has no comments.