Transforming Data

Matt Derda avatar Connor Carreras avatar N
26 articles in this collection
Written by Matt Derda, Connor Carreras, and Nishi Garg

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
Connor Carreras avatar
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
Connor Carreras avatar
Written by Connor Carreras
Updated over a week ago

How to join data

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