Table.Partition |
split the table inlist of tables based on the group. |
tablecolumngroupshash |
Table.Range |
Begin table row from the given range |
tableoffsetcount |
Table.RemoveFirstN |
omit first row of the table |
tablecountOrcondition |
Table.RemoveLastN |
omit last row of the table |
tablecountOrcondition |
Table.RemoveRows |
Removes row of the table |
tableoffsetcount |
Table.RemoveRowsWithErrors |
Removes error value from the given table |
tableColumns |
Table.Repeat |
repeat rows as specified |
tablecount |
Table.ReplaceRows |
Replacess rows as specified |
tableoffsetcountrows |
Table.ReverseRows |
Obtains the entire rows in backwards order |
table |
Table.SelectRows |
Inspect and display the rows which meet the satisfy the condition given by the user |
tablecondition |
Table.SelectRowsWithErrors |
picks only the row has an error value in the table |
tableColumns |
Table.Skip |
skip number of row |
tablecountOrcondition |
Table.SingleRow |
Converts the rows into table |
table |
Table.Column |
Returns the specified data from the column |
tablecolumn |
Table.ColumnNames |
Obtains the column names from the table table |
table |
Table.ColumnsOfType |
retrieves specified types of list from given column in the table |
tablelistoftypes |
Table.DemoteHeaders |
Returnss the column headers to the first row |
table |
Table.HasColumns |
Indicates whether the table have contains the specified column |
tableColumns |
Table.SelectColumns |
inspect and display the columns which satisfy the condition given by the user |
tableColumnsmissingFiled |
Table.PrefixColumns |
prefix the text with all the column names |
tableprefix |
Table.PromoteHeaders |
Returnss the first rows value as the column header |
tableoptions |
Table.DuplicateColumn |
Check whether there is any repetition of the column name |
tablecolumnNamenewColumnNameColunmType |
Table.RemoveColumns |
Removes specific columns from the table |
tableColumnsmissingField |
Table.RenameColumns |
rename specific columns from the table |
tablerenamesmissingField |
Table.ReorderColumns |
rename specific columns from the table |
tablecolumnsOrdermissingField |
Table.TransformColumnNames |
transform columns name from the table |
tablenameGeneratoroption |
Table.InsertRows |
Inserts a row in a table |
|
Table.LastN |
Acquires lastN row |
|
Table.Last |
Acquires last row from the given |
|
Table.MatchesAllRows |
Examines whether all the rows in the table meets the condition |
|
Table.MatchesAnyRows |
Examines whether any of the rows in the table meets the condition |
|
Table.AddColumn |
Adds on new column the table |
table |
Table.FillUp |
Fills the null columns inthe table |
tableoffsetskiptake |
Table.ExpandListColumn |
Expands the given Returns |
tableoffsetrows |
Table.ExpandTableColumn |
Expands columns from the given table |
tablecountorCondition |
Table.TransformRows |
Transforms the row value |
tabledefault |
Table.Transpose |
Converts columns inrows and rows incolumn |
tablecondition |
Table.ToRows |
Returns of nested Returns |
tablecondition |
Table.ToColumns |
Returns of nested Returns |
tablenewColumnNamecolumnGeneratorcolumntype |
Table.Contains |
Inspects whether the specified record, row appears the table |
tablecolumns |
Table.ContainsAll |
Inspects whether the all specified record, row appears the table |
tablecolumn |
Table.ColumnCount |
Returns the number of columns in a table |
tablerowequationCriteria |
Table.AlternateRows |
Takes and skip the give rows (table, offset, skip and take) |
tablerowequationCriteria |
Table.ContainsAny |
Inspect whether any of the specified record, row appears the table |
tablerowequationCriteria |
Table.IsDistinct |
Check whether given rows are distinct |
tablecomparsionCriteria |
Table.PositionOf |
Obtains the row position from the given table input |
tablerowoccurrenceequationCriteria |
Table.PositionOfAny |
Obtains row(s) position(s) from the given table input |
tablerowoccurrenceequationCriteria |
Table.RemoveMatchingRows |
Removes all matching rows |
tablerowequationCriteria |
Table.ReplaceMatchingRows |
Replaces all matching rows |
tablereplacementequationCriteria |
Table.Max |
Obtains the row which has largest value |
tablecomparisonCriteriadefault |
Table.MaxN |
Returns the N Maximum value from the table |
tablecomparisonCriteriacountOrCondition |
Table.Min |
Obtains the row which has smallest value |
tablecomparisonCriteriadefault |
Table.MinN |
Returns the N minimum value from the table |
tablecomparisonCriteriacountOrCondition |
Table.FindText |
Obtains a specific text from the table |
tabletext |
Table.ReplaceValue |
Replaces the old value in the specified columns of the table |
tableoldValuenewValuereplacercolumnsToSearch |
Table.IsEmpty |
Inspect whether the given has any empty rows |
table |
Table.SplitColumn |
Breaks specified column inset of additional column |
tablesourceColumnsplittercolumnNamesOrNumberdefault |
Table.CombineColumns |
Amalgamates specified columns a new column |
tablesourceColumncombinercolumn |
Table.FirstValue |
Returns first value of a column from the table else the value specifiied in the default parameter |
tabledefault |
Table.Schema |
Returnss a table describing the columns of it |
table |
Table.Profile |
Returns a profile for the columns in table |
tableadditionalAggregates |
JoinKind.Inner |
Returns a table resulting from an inner join contains a row for each pair of rows |
|
JoinKind.LeftOuter |
Ensure that all rows of the first table appear in the result |
|
JoinKind.RightOuter |
Ensure that all rows of the first table appear in the result |
|
JoinKind.FullOuter |
Ensure that all rows of both table appear in the result |
|
JoinKind.LeftAnti |
Ensures all rows from the first table that does not have a match in the second table |
|
JoinKind.RightAnti |
Ensures that all rows from the second table, does not have a match in the first table |
|
ExtraValues.Error |
Raise an error if the splitter function ascertains more columns than the table expects |
|
Table.FromValue |
Creates a table with a column |
valueOptions |
Tables.GetRelationships |
Obtains relationships among a set of tables |
tablesdatacolumn |
Table.FromColumns |
Generates table columns from the given Returnss of values |
listscolumns |
Table.FromPartitions |
Combines a set of partitioned tables |
partitionColumnpartitionspartitionColumnType |
Table.PartitionValues |
Returns the table based on the given column values |
tablecolumngroupshash |
Table.FromRows |
Generatess a table from the provided the Returns of rows |
rowscolumns |
Table.RowCount |
Returns the number of columns in a table |
table |
Table.ToRecords |
Converts table inReturnss of records |
table |
Table.FromRecords |
Converts Returnss of records intable |
recordscolumnsmissingField |
Table.AddKey |
Adds a key table |
tablecolumnsisPrimary |
Table.ReplaceKeys |
Replaces a keys from a table |
tablekeys |
Table.First |
Obtains first row of the table |
table |
Table.FirstN |
Obtains first row(s) of the table |
table |
Table.Group |
Groups the rows |
tablekeyaggregatedColumnsgroupKindcomparer |
Table.Join |
Joins the table rows |
table1key1table2key2joinKind |
Table.AddJoinColumn |
Joins the table column |
table1key1table2key2newColumnname |
Table.AddIndexColumn |
Adds index to the table |
tablenewColumnNameintialValueincrement |
Table.FillDown |
Fills the null columns into the table |
tablecolumns |
Table.TransformColumns |
Transforms the column specified |
tabletransfromOperationsdefaultTranformationmissingField |
Table.TransformColumnTypes |
Transforms the column specified |
tabletypeTransformationsculture |
Table.Sort |
Sorts the table |
tablecomparsionCriteria |
Table.Distinct |
Obtains a distinct value |
tableequationCriteria |
Table.ExpandRecordColumn |
Separates column for each field in the record |
tablecolumnfieldNamesnewColumnNames |
Table.AggregateTableColumn |
Aggregates values into multiple column |
tablecolumnaggregations |
Table.Combine |
Merge a list of tables |
tablecolumn |
Table.Pivot |
Summaries of the table |
tablepivotValuesattributeColumnvalueColumnaggregationFunction |
Table.Unpivot |
Unpivot the attribute-value pairs |
tablepivotValuesattributeColumnvalueColumn |
Table.UnpivotOtherColumns |
Unpivot to all columns other than a specified set into the attribute-value pairs |
tablepivotValuesattributeColumnvalueColumn |
Table.ReplaceErrorValues |
Replaces the error with value |
tableerrorReplacement |
Table.Split |
Breaks the table into lists of the table |
tablepageSize |
Table.Buffer |
Buffers a table in memory |
table |
RowExpression.From |
Obtains AST for the function |
function |
RowExpression.Row |
Obtains AST for the row |
|
RowExpression.Column |
Creates AST represents access to column columnName |
ColumnName |
ItemExpression.From |
Obtains AST for the function |
function |
ItemExpression.Item |
Obtains AST for the row |
|
Table.ViewFunction |
Returns View by table |
function |