Transforming Data

How to Standardize your Data

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

Written by Thea
Updated over a week ago

Edit Recipes without Loading Column Histograms

N

Written by Nishi
Updated over a week ago

Edit Recipes without Loading the Sample

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

N

Written by Nishi
Updated this week

How to create and use Macros

Create reusable macros from sequences of steps in your recipe

Written by Thea
Updated over a week ago

How to Union data

Append data from one or more datasets to an existing dataset

Written by Thea
Updated over a week ago

Transformer UI Overview

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

Written by Thea
Updated over a week ago

How to remove identical records from your dataset

Remove duplicate records from your dataset

Written by Thea
Updated over a week ago

How to swap your data source

Replace or Switch datasets in your flow

Written by Thea
Updated over a week ago

How to use the Pattern Profiler

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

Written by Thea
Updated over a week ago

How to use row values as Column Headers

Rename column headers by using values in row(s)

Written by Thea
Updated over a week ago

How to Find & Replace patterns in a column

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

Written by Thea
Updated over a week ago

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

Create a table with selected columns in order

Written by Thea
Updated over a week ago

How to Create a new formula-driven column

Create a new column from the result of a formula

Written by Thea
Updated over a week ago

How to view Column Details

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

Written by Thea
Updated over a week ago

How to Reorder Columns in your dataset

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

Written by Thea
Updated over a week ago

How to change the format of numeric values

Format your numeric columns using NUMFORMAT transform

Written by Thea
Updated over a week ago

How to Edit an existing column

Edit a column with formula

Written by Thea
Updated over a week ago

How to change a column data type

Changing the data types of each column

Written by Thea
Updated over a week ago

How to join data

Combine two datasets based on a common key

Written by Thea
Updated over a week ago

How to Change the format of Text values

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

Written by Thea
Updated over a week ago

How to Rename a Column

Change the name of your columns

Written by Thea
Updated over a week ago

How to filter your data

Remove records from your dataset based on a condition

Written by Connor Carreras
Updated over a week ago

Combine Datasets

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.

Written by Thea
Updated over a week ago

How to edit the Sample size in the Transformer grid

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

Written by Thea
Updated over a week ago

Sample Jobs Page

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

Written by Thea
Updated over a week ago

What is sampling and how does it work?

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

Written by Thea
Updated over a week ago

When should I resample my dataset?

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

Written by Thea
Updated over a week ago

Generating a new sample

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

Written by Thea
Updated over a week ago

Managing samples in complex flows

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

Written by Thea
Updated over a week ago