Cascade Library

Introduction
- Welcome to Cascade
- Workspaces
Getting Started
- Build Your First Workflow
- Build Your First Data App
Workflows
Integrations
Tools
Functions & Expressions
- Functions
- Building Expressions
  - Expression Operators
  - Guide to Window Functions
Cascade FAQs
Change Log

On this page

Inputs
Output
Example

Was this helpful?

NTH

Returns the nth element of a given column

PreviousMATCH NextOFFSET

Last updated 3 years ago

NTH( column, index)

Returns the nth element of a given column

NTH() and INDEX() are aliases of each other.

Inputs

Output

Element within column defined by index

Example

Input

Description

column

Column of any type

index

Index of element to return. Index of 1 returns the first element. index must be within the length of column, otherwise returns an error.