In this article, we will cover how to manually add a new column to a dataset and change the order of columns.
- Click on the Edit button to create a working copy in the dataset which you would like to add a column.
- Once in the working copy click the Edit button again.
Add a new column
The Edit panel will have two sections you will only see in the working copy - the ‘Append and Replace’ section and the ‘Add column’ section. Under ‘Add column’ you need to provide a name and a Data type for the column you want to add. Providing a description is optional. Once you are done configuring your new column click ‘Create’ and your column will get added as the right-most column.
Change Column Order
Column order can be configured from the Manage pane on a published view, from a working copy this can be accessed in the Edit pane. To move your new column to a different position in the dataset you can hover on the left edge of the column header and drag it to where you would like it.
Updating associated views with the new column.
You may have noticed that after adding a new column to a dataset, that it does not automatically appear on views that were created before the column was added.
If you would like to include this newly added column to your view table, all you need to do is navigate to your view, select the manage button, then select the Show and Hide tab, then select the checkbox for the newly added column. Newly added columns will show on the list of fields but by default will not be selected.