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

Saurabh Jain

Administrators
  • Posts

    1,726
  • Joined

  • Last visited

  • Days Won

    61

Everything posted by Saurabh Jain

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