Operator

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.

Class	Function	Operator
CREATE	Create a new table, define schema, enter data	Create table
IMPORT	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 with manual column assignment 3.0 Importing data from SQL sources 5.0 Read TIS table 5.0
TABLE	Transforming tables structure (schema) Renaming columns Reorder columns Delete columns Check specific table structure	Rename, reorder and delete columns 2.0 Delete columns Freeze columns 3.0 Select 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 ) Grouping Aggregating Pivoting Null replacement Time sampling (scaling)	Merge data 5.0 Sort Rows Filter on columns 1.1 Delete rows 2.0 Conversion "String -> Date 2.0" Conversion "String -> Double" Split columns Thread column values Combine columns Mix columns Create Pivot Table V5 Pivot table Resolve pivot table 2.0 Pivot table time x weekdays 2.0 Replacing null values Scaling 8.0
	Spread rows into columns	Create Pivot Table V5
	Gather columns into rows	Resolve pivot table 2.0
CALC	Calculations Time interval Percentage	Length operator As a percentage 4.0
STATISTICS	Special statistical methods Regression SARIMA Outliers	Regression analysis Regression analysis seasonal 7.0 Seasonal ARIMA analysis 5.0 Search for outliers
PROGRAM	Apply program code on tables C# expressions Python scripting formula evaluation Assertion (debug)	Formula operator (row-by-row) (4.0) = Formeloperator Python scripting - with input table Formula interpreter 3.1
INTERACT	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 - Adjust Portlet
PLOT	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
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)	Send e-mail 2.0 Write TIS Table 5.0 Read information of TIS table 3.0 Read TIS table 5.0 Export to CSV file (TIS file system) 2.0 Export to CSV file (server file system) 2.0 Start process 3.0 Recalc Datanodes 1.0... For Each Select data source

Page tree

Operator