Adding new columns to a table

To add new columns to an existing table, click the icon at the top-right of the Data screen.

The list on the left-hand side of the screen will show the existing columns. If a column wasn’t originally added, or you want to create a duplicate of an existing column, you can select it by ticking the relevant box to add it.

If you’re creating a duplicate of an existing column, you must change the name so that it’s unique.

Select the column and click the ‘Generate’ button at the bottom of the screen. Alternatively, you can click ‘Manual Creation’ to create your own column.

If you’re creating your own column, enter a name for the new column, this name must be unique, and then click the ‘Generate’ button at the bottom of the screen.

You will then be able to specify the properties for the new column, for example, whether it is a Dimension or a Measure and enter the Select statement.