5.20. Column operations

Log into the platform and open a workflow that has data in the table. Click in the More link in the top-bar menu. Select the option Column operations . The next page shows the information about the columns:

The buttons at the top of the page are used to perform several operations over the workflow.

5.20.1. Adding columns

The Column button offers the following options:

Add a new column

This function allows you to manually add a new column to the data table. You need to provide the name, a description (optional), the type of data (one of string, number, datetime, or boolean), the position where this column is inserted in the workflow, a date/time window when the columns is visible, an optional comma-separated list of possible value (useful to restrict the values), and an optional initial value.

Add a formula-based column

This function is to create a new column containing the result of the data from existing columns combined with certain basic operations such as maximum , minimum , sum , product , mean , median , etc. The way it works is by selecting the operation and a subset of existing columns to use as operands.

Add a column with random values

This function creates a new column with values randomly taken from a pre-defined collection.