ποΈ ItemExpression.From
Returns the abstract syntax tree (AST) for the body of a function.
ποΈ RowExpression.Column
Returns an abstract syntax tree (AST) that represents access to a column within a row expression.
ποΈ RowExpression.From
Returns the abstract syntax tree (AST) for the body of a function.
ποΈ Table.AddColumn
Adds a column with the specified name. The value is computed using the specified selection function with each row taken as an input.
ποΈ Table.AddFuzzyClusterColumn
Adds a new column with representative values obtained by fuzzy grouping values of the specified column in the table.
ποΈ Table.AddIndexColumn
Appends a column with explicit position values.
ποΈ Table.AddJoinColumn
Performs a join between tables on supplied columns and produces the join result in a new column.
ποΈ Table.AddKey
Adds a key to a table.
ποΈ Table.AddRankColumn
Appends a column with the ranking of one or more other columns.
ποΈ Table.AggregateTableColumn
Aggregates a column of tables into multiple columns in the containing table.
ποΈ Table.AlternateRows
Keeps the initial offset then alternates taking and skipping the following rows.
ποΈ Table.ApproximateRowCount
Returns the approximate number of rows in the table.
ποΈ Table.Buffer
Buffers a table in memory, isolating it from external changes during evaluation.
ποΈ Table.Column
Returns a specified column of data from the table as a list.
ποΈ Table.ColumnCount
Returns the number of columns in the table.
ποΈ Table.ColumnNames
Returns the column names as a list.
ποΈ Table.ColumnsOfType
Returns a list with the names of the columns that match the specified types.
ποΈ Table.Combine
Returns a table that is the result of merging a list of tables.
ποΈ Table.CombineColumns
Combines the specified columns into a new column using the specified combiner function.
ποΈ Table.CombineColumnsToRecord
Combines the specified columns into a new record-valued column where each record has field names and values corresponding to the column names and values of the columns that were combined.
ποΈ Table.ConformToPageReader
This function is intended for internal use only.
ποΈ Table.Contains
Indicates whether the specified record appears as a row in the table.
ποΈ Table.ContainsAll
Indicates whether all of the specified records appear as rows in the table.
ποΈ Table.ContainsAny
Indicates whether any of the specified records appear as rows in the table.
ποΈ Table.DemoteHeaders
Demotes the column headers to the first row of values.
ποΈ Table.Distinct
Removes duplicate rows from the table.
ποΈ Table.DuplicateColumn
Duplicates a column with the specified name. Values and type are copied from the source column.
ποΈ Table.ExpandListColumn
Given a column of lists in a table, create a copy of a row for each value in its list.
ποΈ Table.ExpandRecordColumn
Expands a column of records into columns with each of the values.
ποΈ Table.ExpandTableColumn
Expands a column of records or a column of tables into multiple columns in the containing table.
ποΈ Table.FillDown
Propagates the value of a previous cell to the null-valued cells below in the column.
ποΈ Table.FillUp
Propagates the value of a cell to the null-valued cells above in the column.
ποΈ Table.FilterWithDataTable
This function is intended for internal use only.
ποΈ Table.FindText
Returns all the rows that contain the given text in the table.
ποΈ Table.First
Returns the first row or a specified default value.
ποΈ Table.FirstN
Returns the first count rows specified.
ποΈ Table.FirstValue
Returns the first column of the first row of the table or a specified default value.
ποΈ Table.FromColumns
Creates a table from a list of columns and specified values.
ποΈ Table.FromList
Converts a list into a table by applying the specified splitting function to each item in the list.
ποΈ Table.FromPartitions
Returns a table that is the result of combining a set of partitioned tables.
ποΈ Table.FromRecords
Converts a list of records into a table.
ποΈ Table.FromRows
Creates a table from a list of row values and optional columns
ποΈ Table.FromValue
Creates a table with a column from the provided value(s).
ποΈ Table.FuzzyGroup
Groups rows in the table based on fuzzy matching of keys.
ποΈ Table.FuzzyJoin
Joins the rows from the two tables that fuzzy match based on the given keys.
ποΈ Table.FuzzyNestedJoin
Performs a fuzzy join between tables on supplied columns and produces the join result in a new column.
ποΈ Table.Group
Groups rows in the table that have the same key.
ποΈ Table.HasColumns
Indicates whether the table contains the specified column(s).
ποΈ Table.InsertRows
Inserts a list of rows into the table at the specified position.
ποΈ Table.IsDistinct
Indicates whether the table contains only distinct rows (no duplicates).
ποΈ Table.IsEmpty
Indicates whether the table contains any rows.
ποΈ Table.Join
Joins the rows from the two tables that match based on the given keys.
ποΈ Table.Keys
Returns the keys of the specified table.
ποΈ Table.Last
Returns the last row or a specified default value.
ποΈ Table.LastN
Returns the last specified number of rows.
ποΈ Table.MatchesAllRows
Indicates whether all the rows in the table meet the given condition.
ποΈ Table.MatchesAnyRows
Indicates whether any the rows in the table meet the given condition.
ποΈ Table.Max
Returns the largest row or default value using the given criteria.
ποΈ Table.MaxN
Returns the largest row(s) using the given criteria.
ποΈ Table.Min
Returns the smallest row or a default value using the given criteria.
ποΈ Table.MinN
Returns the smallest row(s) using the given criteria.
ποΈ Table.NestedJoin
Performs a join between tables on supplied columns and produces the join result in a new column.
ποΈ Table.OnError
Description
ποΈ Table.Partition
Partitions the table into a list of tables based on the number of groups and column specified.
ποΈ Table.PartitionValues
Returns information about how a table is partitioned.
ποΈ Table.Pivot
Given a pair of columns representing attribute-value pairs, rotates the data in the attribute column into a column headings.
ποΈ Table.PositionOf
Returns the position or positions of the row within the table.
ποΈ Table.PositionOfAny
Returns the position or positions of any of the specified rows within the table.
ποΈ Table.PrefixColumns
Returns a table where the columns have all been prefixed with the given text.
ποΈ Table.Profile
Returns a profile of the columns of a table.
ποΈ Table.PromoteHeaders
Promotes the first row of values as the new column headers (i.e. column names).
ποΈ Table.Range
Returns the rows beginning at the specified offset.
ποΈ Table.RemoveColumns
Removes the specified columns.
ποΈ Table.RemoveFirstN
Returns a table with the first count rows skipped.
ποΈ Table.RemoveLastN
Returns a table with the last N rows removed.
ποΈ Table.RemoveMatchingRows
Removes all occurrences of the specified rows from the table.
ποΈ Table.RemoveRows
Removes the specified number of rows.
ποΈ Table.RemoveRowsWithErrors
Returns a table with the rows removed from the input table that contain an error in at least one of the cells. If a columns list is specified, then only the cells in the specified columns are inspected for errors.
ποΈ Table.RenameColumns
Applies rename(s) of the form \{old, new}.
ποΈ Table.ReorderColumns
Returns a table with the columns in the specified order.
ποΈ Table.Repeat
Repeats the rows of the tables a specified number of times.
ποΈ Table.ReplaceErrorValues
Replaces the error values in the specified columns with the corresponding specified value.
ποΈ Table.ReplaceKeys
Replaces the keys of the specified table.
ποΈ Table.ReplaceMatchingRows
Replaces all the specified rows with the provided row(s).
ποΈ Table.ReplaceRelationshipIdentity
This function is intended for internal use only.
ποΈ Table.ReplaceRows
Replaces the specified range of rows with the provided row(s).
ποΈ Table.ReplaceValue
Replaces one value with another in the specified columns.
ποΈ Table.ReverseRows
Returns a table with the rows in reverse order.
ποΈ Table.RowCount
Returns the number of rows in the table.
ποΈ Table.Schema
Returns a table containing a description of the columns (i.e. the schema) of the specified table.
ποΈ Table.SelectColumns
Returns a table with only the specified columns.
ποΈ Table.SelectRows
Selects the rows that meet the condition function.
ποΈ Table.SelectRowsWithErrors
Returns a table with only those rows of the input table that contain an error in at least one of the cells. If a columns list is specified, then only the cells in the specified columns are inspected for errors.
ποΈ Table.SingleRow
Returns the single row in the table.
ποΈ Table.Skip
Returns a table with the first count rows skipped.
ποΈ Table.Sort
Sorts the table using one or more column names and comparison criteria.
ποΈ Table.Split
Splits the specified table into a list of tables using the specified page size.
ποΈ Table.SplitAt
Returns a list containing the first count rows specified and the remaining rows.
ποΈ Table.SplitColumn
Splits the specified columns into a set of additional columns using the specified splitter function.
ποΈ Table.StopFolding
Prevents any downstream operations from being run against the original source of the data.
ποΈ Table.ToColumns
Creates a list of nested lists of column values from a table.
ποΈ Table.ToList
Converts a table into a list by applying the specified combining function to each row of values in the table.
ποΈ Table.ToRecords
Converts a table to a list of records.
ποΈ Table.ToRows
Creates a list of nested lists of row values from a table.
ποΈ Table.TransformColumnNames
Transforms column names by using the given function.
ποΈ Table.TransformColumns
Transforms the values of one or more columns.
ποΈ Table.TransformColumnTypes
Applies type transformation(s) of the form \{ column, type } using a specific culture.
ποΈ Table.TransformRows
Transforms the rows of the table using the specified transform function.
ποΈ Table.Transpose
Makes columns into rows and rows into columns.
ποΈ Table.Unpivot
Translates a set of columns in a table into attribute-value pairs.
ποΈ Table.UnpivotOtherColumns
Translates all columns other than a specified set into attribute-value pairs.
ποΈ Table.View
Creates or extends a table with user-defined handlers for query and action operations.
ποΈ Table.ViewError
Creates a modified error record which won't trigger a fallback when thrown by a handler defined on a view (via Table.View).
ποΈ Table.ViewFunction
Creates a function that can be intercepted by a handler defined on a view (via Table.View).
ποΈ Table.WithErrorContext
This function is intended for internal use only.
ποΈ Tables.GetRelationships
Gets the relationships among a set of tables.