> For the complete documentation index, see [llms.txt](https://docs.cascade.io/cascade/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cascade.io/cascade/functions-and-expressions/functions/table.md).

# Table Functions

- [ENCODE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/encode.md): Returns integers for each unique string value in a referenced column.
- [INDEX](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/index.md): Returns the value at a given index inside a column.
- [INDEXBY](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/indexby.md): Returns a value of a specific index within a column, partitioned by the unique values of a separate column
- [FILLNULL](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/fillnull.md): Fills null values with specified replacement value
- [FIRSTBY](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/firstby.md): Finds the first element within a column, partitioned by the unique values of a separate column
- [GENERATEUNIQUEID](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/generateuniqueid.md): Generates Unique IDs
- [LASTBY](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/lastby.md): Finds the last element within a column, partitioned by the unique values of a separate column
- [LOOKUP](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/lookup.md): Returns a row offset a given number of rows from the current row
- [MATCH](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/match.md): Returns the index of a matched value
- [NTH](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/nth.md): Returns the nth element of a given column
- [OFFSET](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/offset.md): Offsets values within a column
- [OFFSETBY](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/offsetby.md): Offsets values within a column, partitioned by the unique values of a separate column
- [PREVIOUSVALUE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/previousvalue.md): Calculate a function's result based on the previous row's values
- [RANK](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/rank.md): Returns the rank of each element in a column
- [RANKBY](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/rankby.md): Ranks values within a column, partitioned by the unique values of a separate column
- [RECORDID](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/recordid.md): Generates IDs for each row in a table
- [ROLLINGAVERAGE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/rollingaverage.md): Calculates the rolling averages of a column
- [ROW](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/row.md): Returns the current row number
- [RUNNINGAVERAGE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/runningaverage.md): Calculates the running average of a column
- [RUNNINGMAX](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/runningmax.md): Calculates the running maximum of a column
- [RUNNINGMIN](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/runningmin.md): Calculates the running minimum of a column
- [RUNNINGSTDEV](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/runningstdev.md): Calculates the running standard deviation of a column
- [RUNNINGTOTAL](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/runningtotal.md): Calculates the running total of a column
- [WINDOWAVERAGE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowaverage.md): Calculates rolling or static window average
- [WINDOWMAX](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowmax.md): Calculates rolling or static window maximum
- [WINDOWMIN](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowmin.md): Calculates rolling or static window minimum
- [WINDOWCOUNT](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowcount.md): Calculates rolling or static window count
- [WINDOWSUM](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowsum.md): Calculates rolling or static window sum
- [SEQUENCE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/sequence.md): Create a sequence of numeric values
- [WINDOWMEDIAN](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowmedian.md): Calculates rolling or static window median
- [WINDOWSTDEV](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowstdev.md): Calculates rolling or static window population standard deviation
- [WINDOWSTDEVP](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowstdevp.md): Calculates rolling or static window population standard deviation
- [WINDOWSTDEVS](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowstdevs.md): Calculates rolling or static window sample standard deviation
- [WINDOWVAR](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowvar.md): Calculates rolling or static window average
- [WINDOWVARP](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowvarp.md): Calculates rolling or static window average
- [WINDOWVARS](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowvars.md): Calculates rolling or static window sample variance
- [WINDOWCORR](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowcorr.md): Calculates rolling or static window average
- [WINDOWCOVAR](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowcovar.md): Calculates rolling or static window population covariance
- [WINDOWCOVARP](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowcovarp.md): Calculates rolling or static window average
- [WINDOWCOVARS](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowcovars.md): Calculates rolling or static window sample covariance
- [SMOOTHEDAVERAGE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/smoothedaverage.md): Calculates the smoothed averages of a column