Transforming Data

Connor Carreras avatar Thea avatar N
29 articles in this collection
Written by Connor Carreras, Thea, and Nishi

How to Standardize your Data

Identify similar values using one of the available algorithms for comparing values -based on spelling or language-independent pronunciation.
Thea avatar
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
Thea avatar
Written by Thea
Updated over a week ago

How to Union data

Append data from one or more datasets to an existing dataset
Thea avatar
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
Thea avatar
Written by Thea
Updated over a week ago

How to remove identical records from your dataset

Remove duplicate records from your dataset
Thea avatar
Written by Thea
Updated over a week ago

How to swap your data source

Replace or Switch datasets in your flow
Thea avatar
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
Thea avatar
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)
Thea avatar
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
Thea avatar
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
Thea avatar
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
Thea avatar
Written by Thea
Updated over a week ago

How to view Column Details

Review additional details about a Column - Profiling information, Statistics and Patterns
Thea avatar
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
Thea avatar
Written by Thea
Updated over a week ago

How to change the format of numeric values

Format your numeric columns using NUMFORMAT transform
Thea avatar
Written by Thea
Updated over a week ago

How to Edit an existing column

Edit a column with formula
Thea avatar
Written by Thea
Updated over a week ago

How to change a column data type

Changing the data types of each column
Thea avatar
Written by Thea
Updated over a week ago

How to join data

Combine two datasets based on a common key
Thea avatar
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...
Thea avatar
Written by Thea
Updated over a week ago

How to Rename a Column

Change the name of your columns
Thea avatar
Written by Thea
Updated over a week ago

How to filter your data

Remove records from your dataset based on a condition
Connor Carreras avatar
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.
Thea avatar
Written by Thea
Updated over a week ago