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


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