Go to Trifacta
All Collections
Transforming Data
Transforming Data
N
27 articles in this collection
Written by
Support,
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
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
Support
Updated over a week ago
Working with Samples
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.
N
Written by
Nishi Garg
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
Support
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
Support
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
Support
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
Support
Updated over a week ago