Saurabh Jain
-
Posts
1,724 -
Joined
-
Last visited
-
Days Won
61
Content Type
Profiles
Forums
Gallery
Downloads
Blogs
Events
Online Conference
The Excel dictionary
Power Query M function dictionary
Everything posted by Saurabh Jain
-
Joins the rows of the tables based on the equality of the keys. The results are entered into a new column.
-
Returns the keys of the specified table.
-
Joins the rows of table1 with the rows of table2 based on the equality of the values of the key columns selected by table1, key1 and table2, key2.
-
Groups table rows by the values of key columns for each row.
-
Returns a table from the table specified where the value of the next cell is propagated to the null values cells above in the column specified.
-
Replaces null values in the specified column or columns of the table with the most recent non-null value in the column.
-
Expands a column of records or a column of tables into multiple columns in the containing table.
-
Expands a column of records into columns with each of the values.
-
Given a column of lists in a table, create a copy of a row for each value in its list.
-
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.CombineColumns merges columns using a combiner function to produce a new column. Table.CombineColumns is the inverse of Table.SplitColumns.
-
Aggregates tables nested in a specific column into multiple columns containing aggregate values for those tables.
-
Adds a key to table.
-
Performs a nested join between table1 and table2 from specific columns and produces the join result as a newColumnName column for each row of table1.
-
Returns a table with a new column with a specific name that, for each row, contains an index of the row in the table.
-
Adds a new column with representative values obtained by fuzzy grouping values of the specified column in the table.
-
Adds a column named newColumnName to a table.
-
Translates all columns other than a specified set into attribute-value pairs, combined with the rest of the values in each row.
-
Given a list of table columns, transforms those columns into attribute-value pairs.
-
Transforms column names by using the given function.
-
Returns a table that contains only specific columns.
-
Returns a table with the columns renamed as specified.
-
Returns a table with specific columns in an order relative to one another.
-
Returns a table without a specific column or columns.
-
Promotes the first row of the table into its header or column names.
