Operators are predefined functions to create or modify tables or  to create graphs in data nodes. An operator is applied to a data node as operation together with its settings. Operations in a data node are aligned in a sequence where each operation manipulates the result of the previous operation.

An operator is added to a data node using the "Add" button in the rightmost column of a data node's "Operations" tab. See Operation page for details on this tab.
Legacy operators can be updated using the "Update operation" button in the "Flags" column of the corresponding operator row, or from within the project properties window. See Upgrade Operator page for details.

See also Operators (alphabetical overview).

Create a new table, define schema, enter data

Import data from external sources:

  • CSV file
  • CSV file with schema definition in XML
  • SQL data source
  • TIS table (shared table store)

Transforming tables structure (schema)

  • Renaming columns
  • Reorder columns
  • Delete columns
  • Check specific table structure


Reshaping and transforming data

  • Combining tables (joining)
    • Inner/semi/anti join
    • left/right/full outer join
    • Intersect, Union, Difference
  • Sorting
  • Filtering
  • Data type conversion
  • Separate (split)
  • Concatenate columns (thread (warning))
  • Grouping
  • Aggregating
  • Pivoting
  • Null replacement
  • Time sampling (scaling)
Spread rows into columns
Gather columns into rows


  • Time interval
  • Percentage

Special statistical methods

  • Regression
  • Outliers

Apply program code on tables

  • C# expressions
  • Python scripting
  • formula evaluation
  • Assertion (debug)

Interaction controls

  • Editable tables (grids)
  • Multiselection
  • Set project parameter
  • Trigger recalculation
  • Change portlet properties


Visualize data in charts

  • Histogram
  • Gantt
  • Heatmap
  • XY Scatters

Trigger an action

  • Send e-mail
  • Export
    • to TIS table (shared table store)
    • to TIS as CSV
    • to file system as CSV
  • Start a process (external program)