Page tree
Skip to end of metadata
Go to start of metadata

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)