Trifacta

Edit Recipes without Loading Column Histograms

For improved performance, you can now edit your recipes without loading a sample in the data grid.

Edit Recipes without Loading the Sample

Identify similar values using one of the available algorithms for comparing values -based on spelling or language-independent pronunciation.

How to Standardize your Data

Create reusable macros from sequences of steps in your recipe

How to create and use Macros

Append data from one or more datasets to an existing dataset

How to Union data

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

Transformer UI Overview

Remove duplicate records from your dataset

How to remove identical records from your dataset

How to swap your data source

See the most common patterns and anomalous patterns of data in a column

How to use the Pattern Profiler

Rename column headers by using values in row(s)

How to use row values as Column Headers

Perform Pattern-based replacements for missing, mismatched, or wrong data using REPLACE Transform

How to Find & Replace patterns in a column

Create a table with selected columns in order

How to re-arrange, replace or drop columns using Select Transform

Create a new column from the result of a formula

How to Create a new formula-driven column

Review additional details about a Column - Profiling information, Statistics and Patterns

How to view Column Details

Change the order of columns - Move column(s) before or after another column

How to Reorder Columns in your dataset

Format your numeric columns using NUMFORMAT transform

How to change the format of numeric values

How to Edit an existing column

How to change a column data type

Combine two datasets based on a common key

How to join data

Format text values - Convert, Trim, Pad, Clean-up and more...

How to Change the format of Text values

How to Rename a Column

Remove records from your dataset based on a condition

How to filter your data

In Trifacta you can merge data together with Joins and Unions. We will describe both features and how to use them on your own data.

Combine Datasets

Connor Carreras

Thea

Nishi

Transforming Data

Change the sample size on a flow/recipe basis to improve UI performance in low memory conditions.

How to edit the Sample size in the Transformer grid

How to track the status of your sampling jobs and cancel jobs if needed

Sample Jobs Page

Trifacta allows you to quickly start working with your dataset by taking a quick sample, but sometimes you may need a little more.

What is sampling and how does it work?

New samples can be generated to get more accurately representative distributions of a dataset's values.

When should I resample my dataset?

When a recipe is created an initial sample is automatically generated at the same time. If needed, you can generate a new one.

Generating a new sample

As your flows grow more complex, you should be aware of how to manage the sampling of your data.