List Functions

Functions for creating, manipulating, and transforming lists.

List.Accumulate
Accumulates a result by applying a function to each item in a list, starting from an initial seed value.
List.AllTrue
Returns true if all values in the list evaluate to true.
List.Alternate
Returns a list with items selected at alternating intervals based on count, repeatInterval, and offset.
List.AnyTrue
Returns true if any value in the list evaluates to true.
List.Average
Returns the average of the values in a list.
List.Buffer
Buffers a list in memory, forcing immediate evaluation and preventing repeated re-evaluation of the source.
List.Combine
Merges multiple lists into a single list.
List.ConformToPageReader
Conforms a list to a page reader table format. Intended for internal use only.
List.Contains
Returns true if a list contains a specified value.
List.ContainsAll
Returns true if a list contains all of the values in another list.
List.ContainsAny
Returns true if a list contains any of the values in another list.
List.Count
Returns the number of items in a list.
List.Covariance
Returns the sample covariance of two lists of numbers.
List.Dates
Generates a list of date values starting from a given date, with a specified count and step duration.
List.DateTimes
Generates a list of datetime values starting from a given datetime, with a specified count and step duration.
List.DateTimeZones
Generates a list of datetimezone values starting from a given datetimezone, with a specified count and step duration.
List.Difference
Returns items from the first list that do not appear in the second list.
List.Distinct
Returns a list with duplicate values removed.
List.Durations
Generates a list of duration values starting from a given duration, with a specified count and step.
List.FindText
Returns all items in the list that contain the given text string. Items must be text values; comparison is case-insensitive.
List.First
Returns the first item in a list, or a default value if the list is empty.
List.FirstN
Returns the first N items from a list, or items from the start of the list while a condition is true.
List.Generate
Generates a list of values using an initial value, a condition, a next function, and an optional selector.
List.InsertRange
Inserts a list of values into a list at a specified index position.
List.Intersect
Returns the intersection of a list of lists, containing only items that appear in every list.
List.IsDistinct
Returns true if the list contains no duplicate values.
List.IsEmpty
Returns true if the list contains no elements.
List.Last
Returns the last item in a list, or a default value if the list is empty.
List.LastN
Returns the last N items from a list, or items at the end of the list that satisfy a condition.
List.MatchesAll
Returns true if the condition function returns true for every item in the list.
List.MatchesAny
Returns true if the condition function returns true for at least one item in the list.
List.Max
Returns the maximum value from a list.
List.MaxN
Returns the N largest values from a list, or values meeting a condition, in descending order.
List.Median
Returns the median value of a list.
List.Min
Returns the minimum value from a list.
List.MinN
Returns the N smallest values from a list, or values meeting a condition, in ascending order.
List.Mode
Returns the most frequently occurring value in the list. If there is a tie, returns the first mode encountered.
List.Modes
Returns all values that appear with the highest frequency in the list (all modes when there is a tie).
List.NonNullCount
Returns the count of non-null values in the list.
List.Numbers
Generates a list of numbers starting from a given value, with a specified count and optional increment.
List.Percentile
Returns the value at the specified percentile(s) in the list. Percentile is expressed as a number from 0 to 1.
List.PositionOf
Returns the zero-based index of the first (or specified) occurrence of a value in a list. Returns -1 if the value is not found.
List.PositionOfAny
Returns the position of the first item in a list that matches any value from a second list.
List.Positions
Returns a list of zero-based index positions for all elements in the given list.
List.Product
Returns the product of all numbers in a list.
List.Random
Returns a list of random numbers between 0 and 1, with an optional seed for reproducibility.
List.Range
Returns a subset of items from a list starting at a given offset.
List.RemoveFirstN
Removes the first N items from a list, or items from the start while a condition is true.
List.RemoveItems
Removes all occurrences of specified values from a list.
List.RemoveLastN
Removes the last N items from a list, or items from the end while a condition is true.
List.RemoveMatchingItems
Removes all occurrences of items found in the second list from the first list.
List.RemoveNulls
Removes all null values from a list, returning only non-null items.
List.RemoveRange
Removes a specified number of items from a list starting at a given index position.
List.Repeat
Returns a list created by repeating the given list a specified number of times.
List.ReplaceMatchingItems
Replaces occurrences of specified values in a list with replacement values, given as a list of {old, new} pairs.
List.ReplaceRange
Replaces a specified number of items in a list starting at a given index with items from a replacement list.
List.ReplaceValue
Replaces occurrences of a specified value in a list with a new value, using a replacer function to perform the substitution.
List.Reverse
Returns a new list with the elements in reverse order.
List.Select
Returns items from a list that match a condition.
List.Single
Returns the single element of a list. Throws an error if the list has zero elements or more than one element.
List.SingleOrDefault
Returns the single element of a list, or a default value if the list is empty. Throws an error if the list has more than one element.
List.Skip
Skips the first N items of a list (or items while a condition is true) and returns the remaining items.
List.Sort
Sorts the items in a list according to the specified criteria.
List.Split
Splits a list into a list of sub-lists, each of a specified maximum size.
List.StandardDeviation
Returns the sample standard deviation of the values in the list.
List.Sum
Returns the sum of all items in a list.
List.Times
Generates a list of time values starting from a given time, with a specified count and step duration.
List.Transform
Applies a function to each item in a list and returns the results.
List.TransformMany
Projects each element of a list to a collection, then applies a result transformation to each (original element, projected element) pair. Similar to SelectMany / flatMap.
List.Union
Returns the union of a list of lists, containing all distinct items from all lists combined.
List.Zip
Transposes a list of lists, combining the Nth elements of each list into new inner lists.