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.

See also Operators (alphabetical overview).

ClassFunctionOperator
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)