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 Operator upgrade page for details.

See also Operators (alphabetical overview).

Class

Function

Operator

create

Create a new table, define schema, enter data

import

Import data from external sources:

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

Transforming tables structure (schema)

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


data

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

calc

Calculations

  • Time interval
  • Percentage
statistics

Special statistical methods

  • Regression
  • SARIMA
  • Outliers
program

Apply program code on tables

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

Interaction controls

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


plot

Visualize data in charts

  • Histogram
  • Gantt
  • Heatmap
  • XY Scatters
action

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)