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. Returns a table containing a description of the columns (i.e. the schema) of the specified table type.
  2. Returns a row type from a table type.
  3. Returns keys from a table type.
  4. Returns the type of a column in a table.
  5. Replaces the keys in a table type.
  6. Replaces the facets of a type.
  7. Returns a record describing the fields of a record type with each field of the returned record type having a corresponding name and a value that is a record of the form [ Type = type, Optional = logical ].
  8. Returns an opened version of a record type, or the same type, if it is already open.
  9. Returns the non nullable type from a type.
  10. Returns an item type from a list type.
  11. Returns whether a record type is open.
  12. Returns true if a type is a nullable type; otherwise, false.
  13. Saurabh Jain

    Type.Is

    Determines if a value of the first type is always compatible with the second type.
  14. Returns a type returned by a function type.
  15. Returns a number indicating the minimum number of parameters required to invoke the a type of function.
  16. Returns a record with field values set to the name of the parameters of a function type, and their values set to their corresponding types.
  17. Returns a Record type from a fields record.
  18. Creates a function type from the given .
  19. Returns the facets of a type.
  20. The given type must be a record type returns a closed version of the given record type (or the same type, if it is already closed)
  21. Add a key to a table type.
  22. Saurabh Jain

    #time

    Creates a time value from hour, minute, and second.
  23. Returns a text value from a Time value.
  24. Returns a record containing parts of a Date value.
  25. Returns the start of the hour.
×
×
  • Create New...