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

Saurabh Jain

Administrators
 View Profile  See their activity

  • Posts

    1,724

  • Joined

  • Last visited

  • Days Won

    61

 Content Type 

Everything posted by Saurabh Jain

  1. Saurabh Jain
    Returns a table where the columns have all been prefixed with a text value.
  2. Saurabh Jain

    Table.Pivot

    Saurabh Jain posted a record in Functions

    Given a table and attribute column containing pivotValues, creates new columns for each of the pivot values and assigns them values from the valueColumn. An optional aggregationFunction can be provided to handle multiple occurrence of the same key value in the attribute column.
  3. Saurabh Jain
    Indicates whether the table contains the specified column(s).
  4. Saurabh Jain
    Duplicates a column with the specified name. Values and type are copied from the source column.
  5. Saurabh Jain
    Demotes the header row down into the first row of a table.
  6. Saurabh Jain
    Returns a list with the names of the columns that match the specified types.
  7. Saurabh Jain
    Returns the names of columns from a table.
  8. Saurabh Jain
    Returns the values from a column in a table.
  9. Saurabh Jain
    Returns a list containing the first count rows specified and the remaining rows.
  10. Saurabh Jain

    Table.Skip

    Saurabh Jain posted a record in Functions

    Returns a table that does not contain the first row or rows of the table.
  11. Saurabh Jain
    Returns a single row from a table.
  12. Saurabh Jain
    Returns a table with only the rows from table that contain an error in at least one of the cells in a row.
  13. Saurabh Jain
    Returns a table containing only the rows that match a condition.
  14. Saurabh Jain
    Returns a table with the rows in reverse order.
  15. Saurabh Jain
    Returns a table where the rows beginning at an offset and continuing for count are replaced with the provided rows.
  16. Saurabh Jain
    Returns a table containing the rows of the table repeated the count number of times.
  17. Saurabh Jain
    Returns a table with all rows removed from the table that contain an error in at least one of the cells in a row.
  18. Saurabh Jain
    Returns a table with the specified number of rows removed from the table starting at an offset.
  19. Saurabh Jain
    Returns a table with the specified number of rows removed from the table starting at the last row. The number of rows removed depends on the optional countOrCondition parameter.
  20. Saurabh Jain
    Returns a table with the specified number of rows removed from the table starting at the first row. The number of rows removed depends on the optional countOrCondition parameter.
  21. Saurabh Jain

    Table.Range

    Saurabh Jain posted a record in Functions

    Returns the specified number of rows from a table starting at an offset.
  22. Saurabh Jain
    Returns information about how a table is partitioned.
  23. Saurabh Jain
    Partitions the table into a list of groups number of tables, based on the value of the column of each row and a hash function. The hash function is applied to the value of the column of a row to obtain a hash value for the row. The hash value modulo groups determines in which of the returned tables the row will be placed.
  24. Saurabh Jain
    Returns true if any of the rows in a table meet a condition.
  25. Saurabh Jain
    Returns true if all of the rows in a table meet a condition.
×
×
  • Create New...