You can add a column to a dataset by clicking the ‘Add column’ button. This can either be a Derived column or a Coordinates column.
With derived columns you can create formulas to change or transform your data. Let’s create a column that shows both port and country names separated by a comma. First we give the column a name: Port and country.
On the left side, we see the columns of our dataset which we can use to build the formula, let’s select Port first. When you click on the blue button in the middle, you can see the different operation categories, each containing specific operators. On the right side, you find more information for each operator as you hover over or click on them, including instructions and an example on how to use the operator.
You can double-click or drag and drop the desired formula into the canvas and add the needed columns and values. We will add a Concatenate operator after our Port, add a comma and space in single quotes, then add another Concatenate before adding the Country column.
By clicking the blue ‘Create’ button, the new column will be created and will appear at the right side of your dataset. You can customize the column further by clicking on the gear icon to the right of its name, and if the resulting values are a number you can also click on the type to select between Numeric, Currency or Duration.
Good to know: Our system has a limit of 10 nesting levels for Derived Columns. What we mean by levels when it comes to Derived columns is basically when a Derived Column is used in the definition of another Derived Column that is used in the definition of another Derived Column....and so on, 10 times/levels over.