Tejas ValakeThe ‘Vector’ task can be used to carry out matrix multiplication or addition of vectors.
Tejas ValakeThe ‘Union’ task can be used to combine and consolidate data from multiple input data tables. The output table of this task, can contain all columns from all input tables, or only the columns that are common to all the input tables.
Tejas ValakeThe ‘Join’ task can be used to combine two data tables. The join may or may not be based on helper columns in both the tables. The helper columns must contain data entries that match. Only the entries that match are joined together in the output table.
Tejas ValakeThe ‘Append’ task can be used to create a merged table from two separate tables. The merged table has data in the first table affixed to the data in the second table.
Tejas ValakeThe ‘Unique’ task can be used to identify all unique entries in a column in a data table. This task can create two tables as output. The first is a table of all first instances of unique entries. The second is table of all other entries. Thus, the ‘Unique’ task can be used a disassemble a data table into unique and duplicate records.
Tejas ValakeThe ‘Transpose’ task can be used to organize and analyse data, and can be used to create numerical and text summaries of data tables.
Tejas ValakeThe ‘Sum-Up’ task can be used to apply a wide range of mathematical and statistical functions to a dataset. It is a useful tool to carry out numerical, statistical, and even text calculations, or to group data ranges together.
Tejas ValakeThe ‘Mirror Matrix’ task can be used to flip a data table along the downward sloping diagonal. This results in row heading in the input table becoming column headings in the output table and vice versa. The ‘Mirror Matrix’ task is a useful tool to quickly reorganize a data table.
Tejas ValakeThe ‘Formula’ task can be used to carry out a variety of custom calculations on numerical or text data. It is a flexible tool to carry out complex numerical or text calculations. The filtering feature and ability to add multiple formulae to a flow make it a powerful tool to carry out complex, multi-level calculations. Furthermore, the ability to add annotations and descriptions at each step helps in reviewing and updating calculations at any time.
Tejas ValakeThe ‘Crosstab’ task can be used to organize and analyse data. This task can be used to quickly create numerical or text summaries of data tables.