List of Operators (functional)

• Create Table

Import data from external sources:

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

• Import text or CSV file 3.0
• Imports text or CSV file with XML structure description
• Importing data from SQL sources 3.1
• Read TIS table 5.0

Transforming tables structure (schema)

• Renaming columns
• Reorder columns
• Delete columns

• Rename, reorder and delete columns
• Delete columns
• Select columns

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 )
• Grouping
• Aggregating
• Pivoting
• Null replacement
• Time sampling (scaling)

• Merge data 4.0
• Sort Rows
• Filter on columns 1.1
• Delete rows
• Conversion "String -> Date 2.0"
• Conversion "String -> Double"
• Split Columns
• Thread column values
  • Combine columns
  • Mix columns
• Create Pivot Table V2
  • Pivot table
• Resolve pivot table 2.0
• Pivot table time x weekdays 2.0
• Replacing null values
• Scaling 7.0

• Create Pivot Table V2

• Resolve pivot table 2.0

Calculations

• Time interval
• Percentage

• Length operator
• As a percentage 4.0

Special statistical methods

• Regression
• SARIMA
• Outliers

• Regression analysis
• Regression analysis seasonal 6.0
• Seasonal ARIMA analysis 5.0
• Search for outliers

Apply program code on tables

• C# expressions
• Python scripting
• Assertion (debug)

• Formula operator (row-by-row) (4.0) = Formeloperator
• Python Scripting
• Freeze columns 2.0

Interaction controls

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

• TIS Board - Read editable data table 5.0
• TIS Board - Multiple selection 3.0
• TIS Board - Recalculate 3.0
• [TIS]Board - Recalculate multi-selection 1.0 (deprecated)
• TIS Board - Adjust Portlet

Visualize data in charts

• Histogram
• Gantt
• Heatmap
• XY Scatters

• TIS Board - TIS Editor Chart
• TIS Board - EJSChart 3.0
• Chart: Standard types 2.0
• Chart: XY Scatter
• Chart: Histogram
• Chart: Histogram Time Pattern
• Chart: Gantt 2D

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)

• Send e-mail 2.0
• Write TIS table 3.0
• Read TIS table information
• Read TIS table 5.0
• Export to CSV file (TIS file system) 2.0
• Export in CSV file (server file system) 2.0
• Start process 2.0