Table Functions

Merges a dimension into the cube's filter context and expands specified dimension attributes as new columns.

Adds a column to the cube containing the results of a measure applied in each row's context.

Returns a cube after applying a parameter with arguments to it.

Returns the unique member identifier from a dimension attribute member property value.

Returns the value of a named property from a dimension attribute member.

Collapses dimension attributes mapped to specified columns, removing them from the cube's tabular view and changing its granularity.

Returns a table containing the set of available dimensions within a cube.

Returns a nested tree of tables representing the display folder hierarchy of objects available in the cube.

Returns a table containing the set of available properties for measures that are expanded in the cube.

Returns the value of a named property from a measure.

Returns a table containing the set of available measures within a cube.

Returns a table containing the set of parameters that can be applied to a cube.

Returns a table containing the set of available properties for dimensions that are expanded in the cube.

Returns the key of a property.

Replaces the set of dimensions returned by Cube.Dimensions for a cube.

Applies a list of cube functions as transforms to a cube.

Creates a table literal from column names and a list of row value lists.

Adds a new column with values computed from a function applied to each row.

Adds a column containing representative cluster values based on fuzzy matching of an existing column.

Adds a sequential index column to a table.

Adds a column of nested tables from a second table by matching each row by key.

Marks specified columns as a key (primary or non-primary) in the table's type metadata.

Adds a rank column to the table based on the specified comparison criteria.

Expands a column of nested tables by applying aggregation functions to each nested table.

Keeps and drops alternating groups of rows based on a repeating keep/drop pattern.

Returns an approximate row count that may be faster than Table.RowCount for large folded queries.

Buffers a table into memory, ensuring it is fully evaluated and its row order is preserved.

Returns a list of all values from the named column.

Returns the number of columns in the table.

Returns the column names of a table as a list of text values.

Returns a list of column names whose types match any of the given types.

Appends multiple tables into a single table by stacking their rows.

Combines multiple columns into a single column using a combiner function.

Combines selected columns into a single record column.

Conforms a table for page-based reading using a shaping function. Intended for internal use only.

Returns true if the table contains a row matching the given record.

Returns true if the table contains all of the specified rows.

Returns true if the table contains any of the specified rows.

Moves the column headers down into the first row of data, replacing them with default column names.

Removes duplicate rows from a table based on all columns or specified criteria.

Duplicates a column in a table with a new name.

Expands a column containing lists into multiple rows, one row per list element.

Expands a column of records into individual columns.

Expands a column of nested tables into individual columns in the parent table.

Replaces null values in specified columns with the most recent non-null value above.

Fills null values in specified columns with the next non-null value below.

Filters a table using a data table identifier. Intended for internal use only.

Returns rows where any cell contains the given text string (case-insensitive).

Returns the first row of the table as a record, or a default value if the table is empty.

Returns the first N rows from a table, or rows matching a condition.

Returns the value in the first row and first column of the table, or a default value if the table is empty.

Constructs a table from a list of column lists, with optional column names and type information.

Converts a list to a table by applying a splitter function to each element.

Creates a table from a list of partition tables with a synthetic partition column added.

Creates a table from a list of records.

Constructs a table from a list of row lists, with optional column names or types.

Wraps a scalar value, list, or record into a table.

Groups rows using fuzzy matching on key column(s), tolerating typos and spelling variations.

Joins two tables using fuzzy (approximate) string matching on key columns.

Joins two tables using fuzzy string matching and produces a nested table column of matches.

Groups rows by key columns and applies aggregation functions to produce summary results.

Returns true if a table contains the specified column or columns.

Inserts a list of row records into the table at the given offset.

Returns true if no two rows in the table are equal.

Returns true if a table contains no rows.

Joins two tables on key columns, returning a flat combined table.

Returns a list of key records defined on the table type.

Returns the last row of the table as a record, or a default value if the table is empty.

Returns the last N rows from a table, or rows matching a condition from the end.

Returns true if every row in the table satisfies the given condition function.

Returns true if at least one row in the table satisfies the given condition function.

Returns the row with the maximum value according to the given comparison criteria.

Returns the top N rows with the highest values according to the given comparison criteria.

Returns the row with the minimum value according to the given comparison criteria.

Returns the N rows with the lowest values according to the given comparison criteria.

Joins two tables on matching key columns and returns the matched rows from the second table as a nested table column.

Partitions a table into a list of tables using a hash function on a specified column.

Returns the partition key of the specified table.

Returns a table describing the partition values for a partitioned data source.

Rotates distinct values from an attribute column into new column headers, aggregating corresponding values.

Returns the zero-based row index of the first (or all) rows matching the given record, or -1 if not found.

Returns the first position of any row in the table that matches any record in the given list.

Prefixes all column names in a table with a given text value.

Returns a profile of the values in each column of a table.

Promotes the first row of a table to column headers.

Returns a specified number of rows from a table starting at a given offset.

Removes the specified columns from a table.

Removes the first N rows of a table, or rows while a condition is true.

Removes the last N rows of a table, or rows while a trailing condition is true.

Removes all rows from a table that match any row in the given list of records.

Removes a specified number of rows starting at a given offset.

Removes rows that contain error values, optionally limited to specified columns.

Renames one or more columns in a table.

Reorders columns in a table to a specified order.

Returns a table that repeats the original table's rows a specified number of times.

Replaces error values in specified columns with replacement values.

Replaces all keys on a table with a new set of key definitions.

Replaces rows that match specified records with new values.

Replaces the partition key of the specified table.

Replaces the relationship identity on a value. Intended for internal use only.

Replaces a specified number of rows starting at an offset with a new set of row records.

Replaces occurrences of a value in specified columns using a replacer function.

Reverses the order of rows in a table.

Returns the number of rows in a table.

Returns a table describing the columns (schema) of the input table.

Returns a table with only the specified columns.

Returns a table of rows from the input table that match a selection condition.

Returns rows that contain at least one error value, optionally limited to specified columns.

Returns the single row of a table as a record. Throws an error if the table does not have exactly one row.

Skips the first N rows of a table, or rows matching a condition.

Sorts the rows of a table using one or more comparison criteria.

Splits a table into a list of tables, each containing at most pageSize rows.

Splits a table into two parts at a given row count, returning both as fields of a record.

Splits a text column into multiple columns using a splitter function.

Returns a new table that prevents any further query folding, forcing local evaluation.

Returns a list of lists, where each inner list contains the values of one column.

Converts a table to a list by applying a combiner function to each row.

Converts a table to a list of records, one record per row.

Converts a table into a list of lists, where each inner list contains the row values.

Transforms column names in a table using the specified function.

Applies transformation functions to the values in one or more columns.

Transforms the types of the specified columns in a table.

Applies a transform function to each row (as a record) and returns a list of the results.

Transposes the table so that rows become columns and columns become rows.

Transforms specified columns into attribute-value pairs, normalizing a wide table into a tall, narrow format.

Unpivots all columns except the specified ones into attribute-value pairs.

Creates a custom view of a table with handler functions that override default operation behavior.

Creates a modified error record that prevents fallback behavior when raised inside a Table.View handler.

Creates a view function that can be intercepted by a Table.View handler.

Associates an error context string with a value. Intended for internal use only.

Returns the relationships among a set of tables structured like a navigation table.