Jump to content
One on One Extensive Advanced Excel Training ×
Business Intelligence & Analytics for Digital Transformation

Saurabh Jain

Administrators
  • Posts

    1,724
  • Joined

  • Last visited

  • Days Won

    61

Everything posted by Saurabh Jain

  1. Performs a fuzzy join between tables on supplied columns and produces the join result in a new column.
  2. Joins the rows from the two tables that fuzzy match based on the given keys.
  3. Groups the rows of a table by fuzzily matching values in the specified column for each row.
  4. Returns a table with a column containing the provided value or list of values.
  5. Creates a table from the list where each element of the list is a list that contains the column values for a single row.
  6. Returns a table from a list of records.
  7. Converts a list into a table by applying the specified splitting function to each item in the list.
  8. Returns a table from a list containing nested lists with the column names and values.
  9. An abstract syntax tree (AST) node representing the row in a row expression.
  10. Returns the abstract syntax tree (AST) for the body of a function.
  11. Returns an abstract syntax tree (AST) that represents access to a column within a row expression.
  12. An abstract syntax tree (AST) node representing the item in an item expression.
  13. Returns the abstract syntax tree (AST) for the body of a function.
  14. Returns a function that splits text according to whitespace.
  15. Returns a function that splits text into a list of text after the specified length repeatedly.
  16. Returns a function that splits text according to the specified ranges.
  17. Returns a function that splits text according to the specified positions.
  18. Returns a function that splits text according to the specified lengths.
  19. Returns a function that splits text by each delimiter in turn.
  20. Returns a function that will split text according to a delimiter.
  21. Returns a function that splits text by any supported delimiter.
  22. Returns a function that splits text into a list of text according to a transition from one kind of character to another.
  23. Returns a function that does no splitting, returning its argument as a single element list.
  24. This function be provided to List.ReplaceValue or Table.ReplaceValue to do replace values in list and table values respectively.
  25. This function be provided to List.ReplaceValue or Table.ReplaceValue to do replace of text values in list and table values respectively.
×
×
  • Create New...