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.

N

Written by Nishi Garg
Updated over a week ago

How to create and use Macros

Create reusable macros from sequences of steps in your recipe

N

Written by Nishi Garg
Updated over a week ago

How to Union data

Append data from one or more datasets to an existing dataset

N

Written by Nishi Garg
Updated over a week ago

Transformer UI Overview

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

N

Written by Nishi Garg
Updated over a week ago

How to remove identical records from your dataset

Remove duplicate records from your dataset

Written by Connor Carreras
Updated over a week ago

How to swap your data source

Replace or Switch datasets in your flow

N

Written by Nishi Garg
Updated over a week ago

How to use the Pattern Profiler

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

N

Written by Nishi Garg
Updated over a week ago

How to use row values as Column Headers

Rename column headers by using values in row(s)

N

Written by Nishi Garg
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

N

Written by Nishi Garg
Updated over a week ago

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

Create a table with selected columns in order

N

Written by Nishi Garg
Updated over a week ago

How to Create a new formula-driven column

Create a new column from the result of a formula

N

Written by Nishi Garg
Updated over a week ago

How to view Column Details

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

N

Written by Nishi Garg
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

N

Written by Nishi Garg
Updated over a week ago

How to change the format of numeric values

Format your numeric columns using NUMFORMAT transform

N

Written by Nishi Garg
Updated over a week ago

How to Edit an existing column

Edit a column with formula

N

Written by Nishi Garg
Updated over a week ago

How to change a column data type

Changing the data types of each column

Written by Connor Carreras
Updated over a week ago

How to join data

Combine two datasets based on a common key

Written by Connor Carreras
Updated over a week ago

How to Change the format of Text values

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

N

Written by Nishi Garg
Updated over a week ago

How to Rename a Column

Change the name of your columns

N

Written by Nishi Garg
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 Matt Derda
Updated over a week ago

Sample Jobs Page

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

N

Written by Nishi Garg
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 Matt Derda
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 Matt Derda
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 Matt Derda
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 Matt Derda
Updated over a week ago