1. Home
  2. Guides
  3. Concepts
  4. Tools
  5. References
    1. Apache Spark
    2. Built-in Functions
      1. Aggregation Functions
      2. Analytic Functions
      3. Boolean Functions
      4. Conditional Statements
      5. Conversion Functions
      6. Filter Functions
      7. Miscellaneous Functions
      8. Arithmetic Functions
      9. Date Functions
      10. String Functions
      11. Query Functions
    3. Incorta Component SDK
    4. Incorta Connector SDK
    5. Connectors
    6. Copilot
    7. Data Studio
    8. Public API
    9. Security
    10. SQL Interface
    11. Visualizations
    12. Other
  6. Integrations
  7. Data applications
  8. Release Notes
  9. Incorta Premium

Built-in Functions → Miscellaneous Functions

The following table lists various functions for finding values in table hierarchies, identifying a schema's last refresh time, and determining the row number in a query:

FunctionSignatureDescription
descendantOf()descendantOf(field, value)Returns true for each record that is descendant of a named parent
descendantOf()descendantOf(field, value, depth)Returns true for each record that is descendant of a named parent down to a specified depth level
getColumn()getColumn(string exp1,..., string expN)Constructs a fully qualified column name by concatenating multiple string parameters. Each parameter is case-sensitive and represents part of the column name. It returns the value of the specified column.
lookup()lookup(result, key, value)Returns a value from a table using primary key values.
schemaRefreshTime()schemaRefreshTime(schema)Returns the last refresh start time of a schema if the system is running.
Should not be used in a physical schema formula column or Analyzer tables.
rowNumber()rowNumber()Returns a sequential number of a row within an insight result set