Multiple Input Tables

Home » Multiple Input Tables » Page 8

Join

The ‘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.
Read more +

Append

The ‘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.
Read more +

Unique

The ‘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.
Read more +

Transpose

The ‘Transpose’ task can be used to organize and analyse data, and can be used to create numerical and text summaries of data tables.
Read more +

Sum-Up

The ‘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.
Read more +

Mirror Matrix

The ‘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.
Read more +

Formula

The ‘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.
Read more +

Crosstab

The ‘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.
Read more +

Clean

The ‘Clean’ task can be used to clean entries in a data table. This task can be used to remove empty records, whitespaces, duplicate values, and specific characters in a data table. It can also be used to change cases of text strings.
Read more +

Binning

The ‘Binning’ task can be used to classify records into different bins or groups. These bins can be in ascending or descending order, and can have fixed or variable intervals.
Read more +