Chapter 2: Basic Operations

Chapter 2: Basic Operations

Overview

In Chapter 2, we will cover basic operations like filtering, splitting, replacing, and extracting data. We will also cover counting patterns and conditional statements.

Lessons:


Lesson A: Uploading and Filtering Data

In the video below, you will:

  • Register for Trifacta (if you haven't already)
  • Create a Flow
  • Upload a Local File
  • Add Transformation Steps to your Recipe
  • Edit, Undo/Redo, Add, and Delete Recipe Steps


Lesson B: String Operations

In this lesson, you will:

  • Learn how to use the following transformations:
    • Set
    • Replace
    • Extract
    • Countpattern
    • Split
  • Learn how to apply transformations to multiple columns


Lesson C: Data Types and Working with Mismatched Data

In this lesson, we will:

  • Learn how to change data types in the Transformer
  • Understand how to use the Settype transform
  • Use the Set Transform in conjunction with the Merge Function


Lesson D: More Conditional Statements

In this lesson, we will:

  • Create a conditional statement using the Case and IF functions
  • Add values between two columns