# Table Functions

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