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


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)