Cascade Library
Ctrlk
  • Introduction
    • Welcome to Cascade
    • Workspaces
  • Getting Started
    • Build Your First Workflow
    • Build Your First Data App
  • Workflows
    • Overview
    • Dynamic Workflows
    • Global Variables
    • Data Locker
    • Scheduling
    • Webhooks
    • Run Logs
    • Workflow Deployment
  • Integrations
    • Connecting Cascade to your database
    • Amazon S3
    • Azure Blob Storage
    • BigQuery
    • Google Sheets
    • MySQL
    • Postgres
    • Redshift
    • SQL Server
    • Snowflake
    • Tableau Server
  • Tools
    • Import
    • Clean
    • Transform
    • Merge
    • Predictive Modeling
    • Flow
    • Code
    • Visualize
    • Publish
  • Functions & Expressions
    • Functions
      • Aggregate Functions
      • Conversion Functions
      • Date/Time Functions
      • Logical Functions
      • Math Functions
      • Table Functions
        • ENCODE
        • INDEX
        • INDEXBY
        • FILLNULL
        • FIRSTBY
        • GENERATEUNIQUEID
        • LASTBY
        • LOOKUP
        • MATCH
        • NTH
        • OFFSET
        • OFFSETBY
        • PREVIOUSVALUE
        • RANK
        • RANKBY
        • RECORDID
        • ROLLINGAVERAGE
        • ROW
        • RUNNINGAVERAGE
        • RUNNINGMAX
        • RUNNINGMIN
        • RUNNINGSTDEV
        • RUNNINGTOTAL
        • WINDOWAVERAGE
        • WINDOWMAX
        • WINDOWMIN
        • WINDOWCOUNT
        • WINDOWSUM
        • SEQUENCE
        • WINDOWMEDIAN
        • WINDOWSTDEV
        • WINDOWSTDEVP
        • WINDOWSTDEVS
        • WINDOWVAR
        • WINDOWVARP
        • WINDOWVARS
        • WINDOWCORR
        • WINDOWCOVAR
        • WINDOWCOVARP
        • WINDOWCOVARS
        • SMOOTHEDAVERAGE
      • Text Functions
    • Building Expressions
  • Cascade FAQs
  • Change Log
On this page

Was this helpful?

  1. Functions & Expressions
  2. Functions

Table Functions

ENCODEINDEXINDEXBYFILLNULLFIRSTBYGENERATEUNIQUEIDLASTBYLOOKUPMATCHNTHOFFSETOFFSETBYPREVIOUSVALUERANKRANKBYRECORDIDROLLINGAVERAGEROWRUNNINGAVERAGERUNNINGMAXRUNNINGMINRUNNINGSTDEVRUNNINGTOTALWINDOWAVERAGEWINDOWMAXWINDOWMINWINDOWCOUNTWINDOWSUMSEQUENCEWINDOWMEDIANWINDOWSTDEVWINDOWSTDEVPWINDOWSTDEVSWINDOWVARWINDOWVARPWINDOWVARSWINDOWCORRWINDOWCOVARWINDOWCOVARPWINDOWCOVARSSMOOTHEDAVERAGE
PreviousSECNextENCODE

Last updated 4 years ago

Was this helpful?