Chapter 4: Advanced Operations

Chapter 4: Advanced Operations

Overview

In Chapter 4, we will cover advanced operations like window functions, creating rows from existing data, and creating columns from existing data without the split transform.

Lessons:


Lesson A: Window Functions

In this lesson, you will:

  • Learn to perform row based operations using Window Functions


Lesson B: Creating Rows from Existing Data

In this lesson, you will:

  • Learn how to extract a pattern as a list
  • Flatten that list vertically into new rows


Lesson C: Creating Columns from Existing Data

In this lesson, we will:

  • Extract key-value pairs from a column
  • Unnest those key-value pairs into new columns