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.